Explain load alternative records / rows into multiple targets - informatica


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

how to calculate the optimum cache size in aggregator transformation?

1 Answers  


wht is full process of Information source to target just like stg to productuon and development

1 Answers   Informatica,


What are the types of lookup?

3 Answers   Wipro,


how to load the data in fact table.. using look up transformation how to view the second record. usally look up shows matching record for only one value. if i have same value its not displaying. ex: problem i faced. i have total, student no and name in table student i used aggregation transformation to display max(total). i have two same max values in total. when i look up the student name and no for this max(total), its showing only one name and no, its leaving the second one. how to rectify it. plz tel me step by step or clearly.

1 Answers  


how will you get 21 to 30 record from 50 records?

6 Answers  






How can we reset Sequence Generator, when we move objects from Dev Environment to QA env?

2 Answers   Rolta,


my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yahoo.com 2000 i want load my data to the target is cno cname sal 100 rama 1000 200 karuna 2000 plz send the answer

5 Answers   IBM, TCS,


Where do you create/define mapping parameter and mapping variable?

1 Answers  


If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

0 Answers  


what is the logic will you implement to laod the data in to one factv from 'n' number of dimension?

3 Answers  


What are connected or unconnected transformations?

0 Answers   Informatica,


What is a node in Informatica?

0 Answers  


Categories