Why joiner transformation does not allow the aggregator
transformation and expression transformation to join
Answers were Sorted based on User's Feedback
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 |
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 |
What is Star Schema?
Store (and count) non-fact records?
what is the synchonus? wht is the diff between synchronous and asynchronous what is the diff between v1 and v2 v3 delta modes in sap ecc
Tell me what is degree of a relation?
What is META DATA information in Data warehousing projects?
If your client approaches you and says that he wants to create a Datawarehouse, and provides just the info regarding his source systems. What are all the neccessary actions one is supposed to take/understand and get back with a comprehensive document which convinces the client to proceed with the DW initiative. What are all the documents we need to provide the client?
what is the diffrence between psa and idoc
What are different stages of ?Data mining??
What is the difference between power center and power mart?
Why facts table is useful in representing the data?
Explain what are the mapping paramaters and maping variables?
Explain me what are conformed dimensions?