Why joiner transformation does not allow the aggregator
transformation and expression transformation to join

Answers were Sorted based on User's Feedback



Why joiner transformation does not allow the aggregator transformation and expression transformatio..

Answer / abhishek

We can join the aggr and epx in joiner even if they are from same source. We Need to check the sorted input property in joiner.

Is This Answer Correct ?    5 Yes 1 No

Why joiner transformation does not allow the aggregator transformation and expression transformatio..

Answer / john

The mapping designer does not allow multiple active transformations or one active and one passive transformation to get connected to same downstream transformation. It would throw an error saying Informatica cannot concatenate the rows passed. However sequence generator is an exception. The mapping designer allows two passive trasnformations to connect to same downstream as passive transformation does not change the number of rows.

Is This Answer Correct ?    4 Yes 2 No

Post New Answer

More Data Warehouse General Interview Questions

I need a good brd and uc template?

0 Answers  


How to provide security in frame work manager for a query subject?

0 Answers  


Explain ddl (data definition language)?

0 Answers  


Explain what is the advantages data mining over traditional approaches?

0 Answers  


Explain how to export mappings to the production environment?

0 Answers  






Explain what is the difference between powerplay transformer and power play reports?

0 Answers  


What are the data marts?

0 Answers  


waht is the advantage of infoset query

0 Answers   iGate,


What is a relationship?

0 Answers  


How do you setup Lo-cockpit?

0 Answers  


Explain the different types of data warehousing?

0 Answers  


what is data validation strategies for data mart validation after loading process

1 Answers  


Categories