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 / 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 do you mean by DTM and Load manager and what is difference between load manager and load balancer?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
How do you convert single row from source into three rows into target?
What is a mapplet/worklet in informatica?
What can we do to improve the performance of informatica aggregator transformation?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
How can repository reports be accessed without sql or other transformations?
How we can create indexes after completing the loan process?
How do you migrate data from one environment to another?
Sequence generator, when you move from develoment to production how will you reset
what are the deliverables?in your project?
Explain Dataware house architecture .how data flow from intial to end?
How to load data in informatica ?
Enlist few areas or real-time situations where informatica is required.