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 / sujatha

I think its wrong ...because aggr is an active trans and
exp is a passive trans....

as per the infa help ...
"You cannot connect an active transformation and a passive
transformation to the same downstream transformation or
transformation input group."....

Is This Answer Correct ?    4 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the shared cache and re-cache?

608


What is meant by a domain?

623


How to generate or load values in to the target table based on a column value using informatica etl tool.

604


What are the components of workflow manager?

584


How many ways are there to do 'remove duplicate records in informatica'?

583






Briefly explain the aggregator transformation?

589


What the difference is between a database, a data warehouse and a data mart?

588


Write the unconnected lookup syntax?

652


What is the cumulative sum and moving sum?

752


Where do we use mapping variables in informatica?

611


How union transformation is used?

585


What is meant by target load plan?

550


What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

1629


Differentiate between a database and data warehouse?

650


COM components can be used in Informatica

1867