In a mapping i have three dimensions. If i want to pass a
same surrogate key value to all the three dimensions by
using one sequence generator is possible?If the mapping is
containing single flow? And in the same case if the mapping
is contaning 3 flows for the three dimensions then by using
one sequence generator can we populate surrogate key (same
value) to all the three dimensions?
Answer Posted / phani
yes we can pass same surrogate key for 3 dimentions. bcz
three dimention are involved in same mapping. we can also
reuse the sequence generator.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Target increases every day even though no new record was inserted
Describe data concatenation?
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?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
how to load rows into fact table in data warehouse
What does command task mean?
Global and Local shortcuts. Advantages.
What are the steps involved in the migration from older version to newer version of Informatica Server?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Can we override a native sql query within informatica?
What is rank transformation?
What is session task and command task?
What are the types of lookup transformation?
What is transformation?
How to differentiate between the active and passive transformations?