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 to use procedural logic inside infromatica?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
Different sorts of metadata that stores in the storage facility?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
Could you explain what is enterprise data warehouse?
Under which circumstances, informatica server creates reject files?
Why is sorter an active transformation?
what is index?how it can work in informatica
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Explain pmcmd command usage in informatica
What is meant by LDAP users?
While migrating the data from one environment to another environment how would you manage the connections?
Mention few advantages of router transformation over filter transformation.
While importing the relational source definition from the database, what are the metadata of source that will be imported?
How big was your fact table