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 / 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
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What is the advantage of informatica?
Can you use flat files in Mapplets.
What is resilience time?
Which is the t/r that builts only single cache memory?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What is the sequence generator transformation in informatica?
what is index?how it can work in informatica
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
server hot-ws270 is connect to Repository B. What does it mean?
How can we handle two sessions in informatica?
Describe an informatica powercenter?
What does reusable transformation mean?
What is the difference between informatics 7x and 8x and what is latest version?
What is a repository manager?