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
- 11528 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
How to update or delete the rows in a target, which do not have key fields?
What is domain in terms of informatica?
How are the sources and targets definitions imported in informatica designer?
How can a transformation be made reusable?
How is union transformation utilized?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What are the databases that informatica can connect to windows?
Target increases every day even though no new record was inserted
Can we create two repositories on same database instance in oracle?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
Explain the different dimensions.
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
EXL informatica Questions
