Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 13753 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / shankar mahadevan
Solution algorithm
1. Sequence Generator – generate the surrogate key
2. Expresion transformation – pass the (step 1) values
3. Connect Output port of (Step 2) to all 3 dimensions
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What does role playing dimension mean?
What is Session and Batches?
How to create the source and target database connections in server manager?
How do you take back up of repository?
On which transformations you created partitions in your project?
How to create Target definition for flat files?
How can we use mapping variables in informatica? Where do we use them?
hi real timers . iam waiting for ur reply regarding ETL TESTING
What are the different types of transformation available in informatica.
What is a filter transformation?
What is blocking transformation?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What is an active transformation?
Explain the different dimensions.
What's the layout of parameter file (what does a parameter file contain?)?
