Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / suraj kedia
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 |
Post New Answer View All Answers
What are the mapping parameters and mapping variables?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What is the meaning of decode in informatica?
What are the advantages of using informatica as an etl tool over teradata?
How do you migrate data from one environment to another?
How do you handle two sessions in Informatica
How many input parameters can exist in an unconnected lookup?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
How to generate sequence numbers using expression transformation?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
can u any challenge your project?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Explain the etl program with few examples.
