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
- 13936 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
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What will be the approach?
How to open an older version of an object in the workspace?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
How to do the error handling of if ur source is flatfiles?
How to create or import flat file definition in to the warehouse designer?
Why do we need informatica?
Explain direct and indirect flat file loading (source file type) - informatica
How can a transformation be made reusable?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What are data-driven sessions?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What is enterprise data warehousing?
What is joiner transformation in informatica?
What is workflow? What are the components of workflow manager?
