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

what is the size of u r source(like file or table)?

0 Answers   HP,


 Informatica Checkpoints

0 Answers   DELL,


Which version configuration tool used in ur project?

0 Answers   CTS, TCS,


Where are the source flat files kept before running the session?

0 Answers   Informatica,


what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

0 Answers  






What are the new features in Informatica 5.0?

1 Answers  


I've a denormalized table EMP(empno,ename,phone,addr1,addr2,fax,email). Now I want to insert the record into target in the format that, there will be 2 target rows for 1 source record. In target the row needs to be inserted as: ROW1: empno,ename,addr1,phone ROW2: empno,ename,addr2,fax,email And I'm not allowed to normalize transformation. How to achieve?

1 Answers   IBM,


How to get rid of non ascii characters in a string? Ex:- United States Microsoft Visual Studio Tools for Applications 2012 x86 主控支援 - 繁體中文語言套件 to United States Microsoft Visual Studio Tools for Applications 2012 x86.

1 Answers   CTS,


Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

0 Answers   Cap Gemini,


wat transf shud i use to achieve this id sal id sal sum src-1 20 tgt 1 20 40 1 20 1 20 40 2 15 2 15 35 2 20 2 20 35

2 Answers  


What is galaxy shema

2 Answers   CGI,


can v update d records in target using update stargey without generationg primary key ? explain

4 Answers   CTS,


Categories