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
- 13930 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 are the performance considerations when working with aggregator transformation?
Write the unconnected lookup syntax and how to return more than one column.
Difference between Target-based loading and constraint-based loading?
lookup transformation with screenshots
Under what condition selecting sorted input in aggregator may fail the session?
What is resilience time?
How to elaborate powercenter integration service?
tell me 5 session failure in real time how can you solve that in your project?
What is Index Caches size?
Informatica Checkpoints
What is decode in static cache?
How we can use union transformation?
What are the settings that you use to configure the joiner transformation?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What are data-driven sessions?
