hw to load this give the mapping?
cty state o/p
c1 s1 c1
c1 s2 s1
c1 s1 c1
c2 s3 s2
c3 s4 c1
c3 s2 s1
c2
s3
c3
s4
c3
s2
2 columns should be loaded to one column in target table?
Answer / balaramesh
first create one normalizer transformation ,double click on
it ,select normalizer tab create column(column name is
cityandstate).set 2 in occurs field and datatype is
string ,next click ok. then automaticaly two input ports
(cityandstate,cityandstate)and threee out pouts
(cityandstate,gk_cityandstate,gcid_cityandstate) are
created.then set city is one inputport(cityandstate) and
state is another input port(cityandstate).set citystate
(outputport) to target table.
| Is This Answer Correct ? | 5 Yes | 0 No |
suppose a session is failed after a transformation , from where that session will run again , i.e . from beginning or from that transformation ?
In which circumstances that informatica server creates Reject files?
Hello...... How can i set my mapping as read-only? Please answer me. Advance thanks
What is main use of mapplet?
Different types of Power center errors?
My source has 100 records. I have targets say in number 5. all target tables has parent and child relationships in between themselves. Now I want to load all 100 records into all targets. How U can ensure that record inserted in parent and then loaded into child.
What is union transformation in informatica?
What is performance tuning in informatica. What measures you will take if some thing is taking much time in your process of ETL?
What are the types of maping wizards that r to be provided in Informatica?
without update strategy how to insert &update?
What is the fact table?
What is the difference between a table and the materialized view?