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
- 13757 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
Differentiate between router and filter transformation?
hi real timers . iam waiting for ur reply regarding ETL TESTING
How to use procedural logic inside infromatica?
How can we use batches?
What are ETL Tools?
what is the size of your data warehousing?
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
What are Dimensional table?
What are the features of complex mapping?
How to create the source and target database connections in server manager?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What are the different clients of powercenter?
What do you understand by term role-playing dimension?
can we override a native sql query within informatica? Where do we do it? How do we do it?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
