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?
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
What is a joiner transformation?
Explain informatica architecture - version 8 / 9
Separate from an archive server and a powerhouse?
Explain what is informatica metadata and where is it stored?
Differences between connected and unconnected lookup?
Differentiate between joiner and lookup transformation?
During the running session, output files are created by informatica server. Enlist few of them.
Why sorter is an active 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?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Mention a few design and development best practices for informatica?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
can we override a native sql query within informatica? Where do we do it?
What is exclusive and normal mode for repository services?