What is the main difference between a Joiner Transformation
and Union Transformation?
Answer Posted / swapna
A joiner Transformation is used to join data from
hertogenous database ie (Sql database and flat file )
where has Union transformation is used to join data from
the same relational sources.....(oracle table and another
Oracle table )
| Is This Answer Correct ? | 10 Yes | 32 No |
Post New Answer View All Answers
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
what is the -ve test case in your project.
How do you set a varible in incremental aggregation
What all join we can perform in LOOKUP transformation?
Explain joiner transformation in informatica
Define pmcmd command?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What is a standalone command task?
What is the benefit of session partitioning?
Explain in detail about scd type 1 through mapping.
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Explain the tuning lookup transformation - informatica
What is joiner transformation?
What is a repository manager?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?