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
- 11364 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
What are data-driven sessions?
What is session task and command task?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What is InformaticaPowerCenter?
What is update strategy transform?
How to differentiate between the active and passive transformations?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
How to elaborate tracing level?
What is confirmed fact in dataware housing?
What are the new features of informatica 9.x at the developer level?
Explian the Process of deployment groups in informatica
Explain where to store informatica rejected data? How to extract the informatica rejected data?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Write the program through which the records can be updated?
r u done any partitions in ur project?
