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 ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to create Target definition for flat files?

746


Enlist some properties of sessions.

612


Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

6452


What are the different versions of informatica?

670


Differentiate between sessions and batches?

564






suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

1724


What is the reusable transformation?

621


What could be the possible resons of locks by user?

655


Explain pushdown optimization and types in informatica

657


What is a router transformation?

618


What is powercenter on grid?

686


What is dimensional table? Explain the different dimensions.

645


I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

1571


Parameter and variable differences

1613


What are the validations that you can perform in oracle and in informatica ? Advance Thanks

1649