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?
Answer Posted / ananta mishra
yes
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Where is metadata stored?
Explain what are the different versions of informatica?
How can we update a record in the target table without using update strategy?
Which is the t/r that builts only single cache memory?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
How to do unit testing in informatica?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What are junk dimensions?
Explain lookup transformation source types in informatica
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Reusable transformation and shortcut differences
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
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?
What are active transformations.
What is primary and backup node?