SRC1 -> EXP -> AGGR ->
TGT
SRC2 -> EXP ->
Above is a maaping with two pipeline connected to the taret
TGT. Design wise is this design is correct or not ?
Answer Posted / sarthak
If the column structure of the two pipelines are same...we
can use UNION t/f to pass data to single TGT instance
or
if we ll take 2 instances of TGT table.... then It ll be
correct...
else we can't connect two pipelines to single TGT instance
directly
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
How to load last n records of file into target table - informatica
How can a transformation be made reusable?
Which are the different editions of informatica powercenter that are available?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
Separate from a database, an information bazaar, and an information stockroom?
can u give example for factless fact table
What are the types of lookup transformation?
What is workflow? What are the components of the workflow manager?
What is the use of source qualifier?
What is meant by pre and post session shell command?
What are the advantages of informatica?
How can we use batches?
How many ways a relational source definition can be updated and what are they?
can any one give some examples for pre sql and post sql(Except dropping and creating index).