what is diffrence b/w joner and union transfermation
Answer Posted / chandrp
At the maximum a join trasformation can join only 2 tables.
but union transformation will join more than two tables at
a time.
| Is This Answer Correct ? | 10 Yes | 8 No |
Post New Answer View All Answers
What are the tasks that can be performed using sq?
What is an expression transformation in informatica?
What is the sequence generator transformation in informatica?
What is the benefit of session partitioning?
Where are the source flat files kept before running the session?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What are the types of caches in lookup?
Explain transaction control transformation in informatica
what is diff b/t sorter t/r and agg have the option sorter property...
Which files are created during the session rums by informatics server?
What is fact table? Explain the different kinds of facts.
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Slowly changing dimensions, types and where will you use them
What is native users?
What are the different options available for update strategy?