Interested to Buy Any Domain ? << Click Here >> for more details...
explain abt union t/r?
- 1 Answers
- 4453 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 |
performance tuning of Informatica
How can you display only hidden files in UNIX
How do you load first and last records into target table?
Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?
How the informatica server sorts the string values in Rank transformation?
what is the diff b/w cached and unchaed look ups
The Source coloumns are A,B,C with data row1- 10,20,30 row2- 40,50,60 row3-70,80,90 and so on. In the target I want one coloumn with the following data, Coloumn-X, row1-10,row2- 20,row3-30,row4-40,row5-50 and so on. How to achieve this?
Is there any model difference between ODS and DWH
After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?
What are the guidelines to be followed while using union transformation?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
Hi, source data is col1 values are 5,6,7 col2 are 3,2,1 col3 are 8,9,10 and i want to get target as col1 5,6,7 col2 1,2,3 col3 8,9,10 how to do this one?
Teradata 
