Explain load alternative records / rows into multiple targets - informatica
No Answer is Posted For this Question
Be the First to Post Answer
how to calculate the optimum cache size in aggregator transformation?
wht is full process of Information source to target just like stg to productuon and development
What are the types of lookup?
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.
how will you get 21 to 30 record from 50 records?
How can we reset Sequence Generator, when we move objects from Dev Environment to QA env?
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
Where do you create/define mapping parameter and mapping variable?
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?
what is the logic will you implement to laod the data in to one factv from 'n' number of dimension?
What are connected or unconnected transformations?
What is a node in Informatica?