what is the mechanism of the Master-Detail joining
condition?
Answer Posted / chinni
it is nothing but the informatica server just returns the
all rows from details table and matched records from master
table.
the table which contains less records taken it as a master n
another table as a detail,b'coz for performance purposes.
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What is mapping debugger?
What is Cognos script editor?
How can we use batches?
What are the different clients of powercenter?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
Explain dynamic target flat file name generation in informatica
r u done any partitions in ur project?
Where is metadata stored?
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.
How do you load only null records into target? Explain through mapping flow.
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
Explain the difference between a data warehouse and a data mart?
How can repository reports be accessed without sql or other transformations?
Do you find any difficulty while working with flat files as source and target?