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 / abhishek
yes offcourse we can do it
for understandi this you can refer SCD2 version it haapens
same like ur qustion
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do you remove duplicate records in informatica? And how many ways are there to do it?
Describe the impact of several join conditions and join order in a joiner transformation?
Explain how to import oracle sequence into informatica?
Explain joiner transformation in informatica
Explain the different kinds of facts.
How to configure mapping in informatica?
What is informatica?
What are the new features of Power Center 5.0?
EXL informatica Questions
Enlist the various types of transformations.
What are the types of schemas we have in data warehouse.
What is Data Caches size?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
How many ways a relational source definition can be updated and what are they?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?