Interested to Buy Any Domain ? << Click Here >> for more details...
I am having two tables,say table1 having cols
Empid,firstname,lastname,middlename and table2 having
Empid,firstname,lastname can i union them using Union t/f?
- 6 Answers
- 11348 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / sreenu
It is not possible to put both in Union directly,
The group coming to Union must have same number of columns
and its data type must be compatible.
In this case first table has 4 columns and the second table
has 3 only.
alternatively you can follow the below logic to pass to
union transformation
Because the 2nd table has only 3 columns, create dummy
column for the 2nd flow and pass null in that port, so that
you can connect them to Union
| Is This Answer Correct ? | 30 Yes | 4 No |
Post New Answer View All Answers
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
How do you load only null records into target? Explain through mapping flow.
While migrating the data from one environment to another environment how would you manage the connections?
What is meant by active and passive transformation?
Explain the informatica workflow?
Explain what are the different types of transformation available in informatica.
What is the scenario which compels informatica server to reject files?
What are the different transaction levels available in transaction control transformation?
What is the status code in stored procedure transformation?
How can we improve session performance in aggregator transformation?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What is the function of aggregator transformation?
What is dimensional table?
What is a pre-defined event and user-defined event?
lookup transformation with screenshots
