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
- 13703 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 or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
How can we use mapping variables in informatica? Where do we use them?
server hot-ws270 is connect to Repository B. What does it mean?
complex mapping ur project u r invlve can u explain and give real time example give me ?
my source is junk data how will u remove that junk data by using unix please any one replay me
What is the difference between a repository server and a powerhouse?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What differs when we choose the sorted input for aggregator transformation?
How can we create index after completion of load process?
What is union transformation in informatica?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Can we change Dynamic to Static or Persistent cache? If so what happens?
What is mapplet in informatica?
How to go to the older version for a mapping?
What are the new features of informatica 9.x developer?
