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?

Answers were Sorted based on User's Feedback



In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the thre..

Answer / 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

In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the thre..

Answer / shankar mahadevan

Solution algorithm

1. Sequence Generator – generate the surrogate key
2. Expresion transformation – pass the (step 1) values
3. Connect Output port of (Step 2) to all 3 dimensions

Is This Answer Correct ?    3 Yes 0 No

In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the thre..

Answer / 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

In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the thre..

Answer / uzval_vee

u can pass same surrogate key to three dimensions ,this is
possible in case 2 i.e 3 flows,according to my view

Is This Answer Correct ?    1 Yes 0 No

In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the thre..

Answer / abhishek

yes offcourse we can do it
for understandi this you can refer SCD2 version it haapens
same like ur qustion

Is This Answer Correct ?    0 Yes 0 No

In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the thre..

Answer / phani

yes we can pass same surrogate key for 3 dimentions. bcz
three dimention are involved in same mapping. we can also
reuse the sequence generator.

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Informatica Interview Questions

What are the differences between source qualifier and joiner transformation?

0 Answers  


source name sal aaaa 2000 bbbb 3000 abcd 5000 Target name sal aaaa 2000 bbbb 3000 abcd 5000 total 10000 how to get total as new row and sum as 10000 thanks

4 Answers   Polaris,


How would you join a node to the already existing domain?

0 Answers  


1 lac of flat fles in source how to load target at a time?

4 Answers   Cap Gemini,


Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??

3 Answers   IBM,


How can we handle two sessions in informatica?

0 Answers  


why union is active transformation?

4 Answers   IBM,


How will u pas the data with out debugger?

4 Answers  


what is the predefined port in dynamic lookup

2 Answers  


What is repository manager?

0 Answers  


if the session fails after 100 records agian we have to starts the session or we go for recovery session

2 Answers   TCS,


What are batches?

0 Answers  


Categories