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
- 11401 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
How to load the data from people soft hrm to people soft erm using informatica?
How many dimensions are there in informatica?
What are the different lookup cache(s)?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
r u done any partitions in ur project?
How to load a Dimension ? and how to load a fact table?
What are the components of Informatica? And what is the purpose of each?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What does command task mean?
Explain about cumulative Sum or moving sum?
have u done any performance tuning? how u ll do?
What differs when we choose the sorted input for aggregator transformation?
Differences between connected and unconnected lookup?
How many ways are there to do 'remove duplicate records in informatica'?
State the differences between sql override and lookup override?
