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
- 11387 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
Target increases every day even though no new record was inserted
Why do you use Mapping Parameter and mapping variable?
Can we override a native sql query within informatica?
Explain sessions and how many types of sessions are there?
What is a grid in Informatica?
What is the use of source qualifier?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
In informatics server which files are created during the session rums?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
Differentiate between router and filter transformation?
What is a connected transformation?
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 are batches?
How to load data in informatica ?
