Interested to Buy Any Domain ? << Click Here >> for more details...
Why joiner transformation does not allow the aggregator
transformation and expression transformation to join
- 2 Answers
- 9955 Views
- I also Faced
- E-Mail Answers
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 |
How to pivot data using informatica when you have variable amount of pivot rows?
What is Snow Flake Schema design in database?
What is data merging, data cleansing and sampling?
how can one connect two fact tables ? is it possible ? how?
After the generation of a report to whom we have to deploy or what we do after the completion of a report?
Explain the difference between dw and bi?
"A dimension table is wide but the fact table is deep," explain the statement in your own words.
Can you explain how analysis service works?
What is a Data Warehouse?
How can we transform row to column?
What are the types of dimensional modeling?
what is table partitioning? How it is useful to warehouse database?
Teradata 
