explain abt union t/r?
- 1 Answers
- 4009 Views
- IBM, I also Faced
- E-Mail Answers
A union transformation is a multiple input group
transformation,which is used to merge the data from multiple
sources similar to UNION All SQL statements to combine the
results from 2 or more sql statements.
Similar to UNION All statement, the union transformation
doesn't remove duplicate rows.
It is an active transformation.
| Is This Answer Correct ? | 5 Yes | 1 No |
What do think which one is the better joiner or look up?
What are the hard ware required for a normal sized data warehouse? and What are the software required for a normal kind of data warehouse?
How does the server recognize the source and target databases. Elaborate on this.
in a table it has 200 rows the query is select 150 from tablename.whats the output
if we have a delimiters at unwanted places in a flat file how can we over come those.
How do we call shell scripts from informatica?
How can repository reports be accessed without sql or other transformations?
What are the issues that you have faced while moving your project from the Test Environment to the Production Environment? Please explain in depth thanks in advance
What are the new features in Informatica 5.0?
What is the use of target designer?
What is the meaning of up gradation of repository?
what is casual dimension?
Teradata 
