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
What are mapplets?
How can a transformation be made reusable?
What is the need of an ETL tool?
What is substr in informatica?
How to elaborate powercenter integration service?
In warehouses how many schemas are there?
What do you mean by filter transformation?
How to implement security measures using repository manager?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Please let me know how to make encryption and decryption with example?
Differentiate between source qualifier and filter transformation?
What is meant by incremental aggregation?
How to extract the informatica rejected data?
what is $$$$?
What are the differences between source qualifier and joiner transformation?