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
- 11379 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sumana
Hi i have a samll doubt on this
Three dimensions are in same mapping but three different
flows. 3 diffrent flows means when the first completes then
only the second flow will start in this case by use one
sequence generator how will we pass the same values to all
the three dimensions. The surrogate key value should pass
like this for all the dimensions
dim1 dim2 dim3
---- ---- -----
1 1 1
2 2 2
3 3 3
4 4 4
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How can we improve session performance in aggregator transformation?
tell me about your project functionality
How to convert multiple rows to single row (multiple columns) in informatica
How to configure mapping in informatica?
What is the difference between a connected look up and unconnected lookup?
What is the fact table?
what is song in infrmatica...?
what is the size of your data warehousing?
Please let me know how to make encryption and decryption with example?
How to partition the Session?
Explain the different lookup methods used in informatica?
What are the different types of transformation available in informatica.
What are the different versions of informatica?
Define the various join types of joiner transformation?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
