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
How can we delete duplicate rows from flat files?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
where to store informatica rejected data? How to extract the informatica rejected data?
Explain in detail about scd type 1 through mapping.
What are multi-group transformations?
What are the static cache and dynamic cache in informatica?
How can we handle two sessions in informatica?
How will the document be delivered to me?
What is informatica metadata and where is it stored?
Write the prerequisite tasks to achieve the session partition?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What is the format of informatica objects in a repository?
What is the function of union transformation?
What are active and passive transformations?
Which development components of informatica have the highest usage?