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?

Answers were Sorted based on User's Feedback



Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from ..

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

Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from ..

Answer / ananta mishra

yes

Is This Answer Correct ?    4 Yes 0 No

Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from ..

Answer / ananta mishra

yes

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Informatica Interview Questions

suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping using aggregator & router? how

7 Answers   TCS,


HOW DO YOU CONNECT TO REMOTE SERVER ?

1 Answers   Patni, TCS,


What are the uses of etl tools?

0 Answers  


What is repository manager?

0 Answers  


How do you change parameter when you move it from development to production.

1 Answers  






how can i invoke pmcmd in command line prompt

1 Answers  


In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal. Is there any othere transformation than the aggrator? if yes how?

5 Answers   Patni,


My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? means only one source qualifier has 2 columns like empno, sal. connected to same target as shown in above mapping.Is this mapping valid or any issues are there if we design like this?

2 Answers   Span Systems,


what is the diff b/w union and joiner and lookup?

4 Answers  


delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses

2 Answers   Motorola,


I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,

3 Answers   CSC,


hw cn v elimate dublicate values from lookup without overriding sql?

7 Answers   CTS,


Categories