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
- 13495 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
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What do think which one is the better joiner or look up?
How to join three sources using joiner?
What is target load order?
What is parallel processing in informatica?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What is difference between a gateway node and worker node?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What are the different versions of informatica?
Differentiate between Load Manager and DTM?
Mention some types of transformation?
What are the different options available for update strategy?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
What is the commit type if you have a transaction control transformation in the mapping?
Why do you use Mapping Parameter and mapping variable?
