explain abt union t/r?
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 |
AT the max how many transformations and mapplets can we use in a mapping ?
1 Answers Cap Gemini, Cognizant,
Is it possible to create multiple domains on a single Informatica server?
what happens if you try to create a shortcut to a non- shared folder?
I want load the data into target with out 1st and last record.
How to differentiate between the active and passive transformations?
how will u get 1 and 3rd and 5th records in table what is the query in oracle please help me
what is INFORMATICA TESTING process
How can u insert o ne row in the target if that row does not exists in the target and update if it exists
What is a node in Informatica?
What are Business Components in Informatica?
Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR IN ORACLE & INFORMATICA LEVEL HOW TO ACHIVE
What is Collect performance data in informatica and what is the use of it.