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


Please Help Members By Posting Answers For Below Questions

Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

1647


How to load last n records of file into target table - informatica

593


How can a transformation be made reusable?

658


Which are the different editions of informatica powercenter that are available?

553


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. ?

1599






Separate from a database, an information bazaar, and an information stockroom?

601


can u give example for factless fact table

5506


What are the types of lookup transformation?

627


What is workflow? What are the components of the workflow manager?

631


What is the use of source qualifier?

662


What is meant by pre and post session shell command?

615


What are the advantages of informatica?

564


How can we use batches?

598


How many ways a relational source definition can be updated and what are they?

573


can any one give some examples for pre sql and post sql(Except dropping and creating index).

3497