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 / uzval_vee
u can pass same surrogate key to three dimensions ,this is
possible in case 2 i.e 3 flows,according to my view
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what are 3 tech challenges/ common issues you face?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What is depict expression change?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What is pmcmd command?
How are the sources and targets definitions imported in informatica designer?
How to load the data from people soft hrm to people soft erm using informatica?
What is aggregator transformation in informatica?
What is meant by pre and post session shell command?
what is the complex transformation you used in informatica
Define mapplet?
server hot-ws270 is connect to Repository B. What does it mean?
How you know when to use a static cache and dynamic cache in lookup transformation?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
How do you manage the Parameter files while migrating your data from one environment to another environment?