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 if the source is a flat-file? Then how can we remove the duplicates from flat file source?

1 Answers  


Can we run session without using workflows?

5 Answers   TCS,


where does the default group roew in a router is stored what is the default size of memory in router

1 Answers  


What is Micro Strategy? Why is it used for?

5 Answers   Infosys,


In Which scenario did u used Incremental loading?

2 Answers  


What is meant by a domain?

0 Answers  


Can anyone guide me the steps to install informatica PC 8.5.1 with database as oracle

1 Answers  


I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

0 Answers  


Without using any transformations how u can load the data into target?

15 Answers   IBM,


Can i create a lookup table without cache.

7 Answers   iGate,


Can anyone please help me out,In which transformations records will be rejected and how capture those records?and How to reload the rejected records?

3 Answers   Syntel,


what type of transformation is not supported by mapplets?

4 Answers   CTS,


Categories