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?
- 6 Answers
- 11402 Views
- IBM, I also Faced
- E-Mail Answers
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
Explain where to store informatica rejected data? How to extract the informatica rejected data?
How to delete duplicate row using informatica?
What do think which one is the better joiner or look up?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Write the different tools in the workflow manager?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What is resilience time?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is the difference between a connected look up and unconnected lookup?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
How you know when to use a static cache and dynamic cache in lookup transformation?
Explain the types of lookup transformation?
How do you use reject loader.
How to generate sequence numbers?
What is the need of etl tools?
