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 is resilience time?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What is DR strategy for Informatica project?
How to extract sap data using informatica?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
without table how to come first record only in oracle?
What is mapping debugger?
How can we use mapping variables in informatica?
How do you take back up of repository?
Mention a few design and development best practices for informatica?
How to improve the performance of a session using sorter transformation?
What is informatica metadata and where is it stored?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?