How to apply rules to columns in the target

[kasiras]

i am new to INFA..,

i would like to apply some rules to the target column..,i need to apply particular rule to the target column..,so in evry column in the target i need to apply certain rule..,

what is the process to do it and which transformations i need to use..,

please help me..,

 

[blom0344]

Okay, that is 3 times the question how to use a rule.
Now, for starters what do you mean by 'rule' ?

default? trigger?

Ties Blom

 

[kasiras]

hi ..,
let me explain abut my scenario..,
3 sources
1)cncpull
cncp_id pk
cncp_nm
2)mcv
cid - int
concpt_id - int
strv - nvrchar
updtime- date
numv - float
datev - date

3)mcvl
cid - int
concpt_id - int
strv - nvrchar
updtime- date
numv - float
datev - date

Target
mmscvl
mcvl_id -Auto generated number
meme_ck -match cid on mcv/mcvl to mcv.cid=10
cncp_id -cncpull.cncp_id

cncp_str_value-where cncpull.cncp_id=mcv.cncp_id
cncp_update_time -where cncpull.cncp_id=mcv.cncp_id
cncp_num_value -where cncpull.cncp_id=mcv.cncp_id
cncp_dt_value -where cncpull.cncp_id=mcv.cncp_id

cncp_str_value-where cncpull.cncp_id=mcvl.cncp_id
cncp_update_time -where cncpull.cncp_id=mcvl.cncp_id
cncp_num_value -where cncpull.cncp_id=mcvl.cncp_id
cncp_dt_value -where cncpull.cncp_id=mcvl.cncp_id

i would like to apply the following rules to get the data into target..,

so i need to know that which transformations shoul i use to get the date..,

just give me the details

thanks in advance
shashi

 

[ArtieChoke]

huh? Your target examples are the same in both sections so I'm not clear what you want.

Basically, if you want to manipulate data, use an expression transformation. See help on how to set them up. You can set up test conditions and choose which value you want to output based on the inputs. Depending on your need, you could also use a router.

It sounds like you need to play around and see how the tool works first.

"I think we're all Bozos on this bus!" - Firesign Theatre

 

[blom0344]

'just give me the details'

Yeah right!

I'd say follow ArtieChoke's advice and learn how it works.
Keywords: joins,expression transformation,filtering and perhaps routing.


Ties Blom