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
- 13705 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
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 |
1)what is the use of bottlenecks in informatica. 2)where we are use shellscripting. 3)what meant by informatica.
Can we use unconnected lookup as dynamic lookup?
5 Answers ITC Infotech, TCS, Wipro,
My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?
While migrating the data from one environment to another environment how would you manage the connections?
what are objects in data warehouse?
if soource is having 10 records how will u insert 20 records to target
how can u approach u r client
Which means the first record should come as last record and last record should come as first record and load into the target file?
in my source i have 100 records, and 3 targets, i want to load 1st record into 1st target,2nd record into 2nd target,3rd record into 3rd target again 4th target into 1st target and vice versa,how to achieve this?
What is an aggregator transformation?
what is the main advantage of unconnected lookup
MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104 MY REQUIRMENT IS NAME ID VENKATESH 101 RAJESH 102 SIVA 103 SWATHI 104 PLEASE PROVIDE ME THE SOLUTION
Teradata 
