Interested to Buy Any Domain ? << Click Here >> for more details...
Can we use Union Transformation for Heterogeneous sources?
i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?
- 3 Answers
- 10326 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / chandrababu.sarupuru
Union Transformation allows the Hetrogeneous sources .
So you can join the sources which are having same metadata.
| Is This Answer Correct ? | 12 Yes | 0 No |
How to create Target definition for flat files?
Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can you use them in the mapping?
hi all, can anyone tell where i will get good informatica training in Pune? thanks in advance.
On a day, I load 10 rows in my target and on next day if I get 10 more rows to be added to my target out of which 5 are updated rows how can I send them to target? How can I insert and update the record?
How do you load alternate records into different tables through mapping flow?
How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...
One flatefile it contains some data but i want to dont want to load first and last record ..how it is? can u tell me complete logic?
hw cn v elimate dublicate values from lookup without overriding sql?
Different sorts of metadata that stores in the storage facility?
can session assigned multiple mappings or not?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
what is procedure to use mapping variable in source qualifier transformation? with example
Teradata 
