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
- 13935 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / raj
Use the Sequence and Expresion transfermations.first
genarate the surrogate with Seq trans,then send values to
exp trans,connect the exp trans o/p ports to 3 dimentions.
First Seq generate the surrogate key like 1,2,3,4,5
we wil pass this column to next tran(Exp) from there we
will connect o/p port to dimentions.so '1' wil go all
dimentions,then '2' wil go then '3' .....
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
In informatics server which files are created during the session rums?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What is a sorter transformation?
Plz can any one say me how to get the informatica certification materials and dumps
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What are the different options available for update strategy?
How to generate sequence numbers without using the sequence generator transformation?
Differences between version 7.x and 8.x.
What is incremental aggregation?
Describe data concatenation?
Parameter and variable differences
How to do unit testing in informatica?
How to partition the Session?
explan ur project architecture?
