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
How to load a Dimension ? and how to load a fact table?
Name the different lookup cache(s)?
What is the reusable transformation?
How many ways are there to create ports?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Clarify the utilization of aggregator cache record?
What are the mapping parameters and mapping variables?
What do you mean by channel change?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
how to load rows into fact table in data warehouse
How to load the data from people soft hrm to people soft erm using informatica?
What are the databases that informatica can connect to windows?
Partition, what happens if the specified key range is shorter and longer
Define filter transformation?
What is an expression transformation?