What is the main difference between a Joiner Transformation
and Union Transformation?
- 5 Answers
- 30521 Views
- I also Faced
- E-Mail Answers
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
What is a surrogate key?
differences between service based and product based?
What if the source is a flat-file?
Under which circumstances, informatica server creates reject files?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
How do you convert single row from source into three rows into target?
How can we remove the duplicates from flat file source?
Which is the t/r that builts only single cache memory?
What are the restrictions of union transformation?
What do think which one is the better joiner or look up?
lookup transformation with screenshots
What is an active transformation?
How to update or delete the rows in a target, which do not have key fields?
