how to join the two flatfiles using the joiner t/r if there
is no matching port?
Answer Posted / alisha
Hi Sudhar
What condition we need to give in Joiner transformation to
join tht dummy column.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
can we override a native sql query within informatica? Where do we do it? How do we do it?
What is meant by query override?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Describe an informatica powercenter?
What is persistent lookup cache?
Explain the different lookup methods used in informatica?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What is an aggregator transformation?
Define sessions in informatica etl?
What do you mean by filter transformation?
Plz can any one say me how to get the informatica certification materials and dumps
According to his methodology what all you need before you build a datawarehouse
Explain the difference between mapping parameter and mapping variable?