After dragging the ports of 3 sources
sqlserver,oracle,informix to single source qualiofier can
we map these ports directly to target and how?

Answers were Sorted based on User's Feedback



After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can ..

Answer / rao

How can you join 3 heterogeneous sources to a single source
qualifier?.
For this you need to use 2 joiner transformations and the
resulted cloumns can be connected to the target.

Is This Answer Correct ?    11 Yes 0 No

After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can ..

Answer / veeru

No,

By joining the three sources, we can load in to the target

Is This Answer Correct ?    0 Yes 5 No

Post New Answer

More Informatica Interview Questions

hi real timers . iam waiting for ur reply regarding ETL TESTING

0 Answers  


tell me some dimension tables names in banking domain informatica project(dont tell like depends on project, tell me names of dimension and fact table names in your project)?

3 Answers   IBM, Patni, TCS,


What happens if we dont select data driven option?

2 Answers   Zensar,


What is the difference between Active and Passive transformation?

0 Answers   Informatica,


How can you recognise whether or not the newly added rows in the source r gets insert in the target ?

2 Answers  






Which files are created during the session rums by informatics server?

0 Answers  


Can anyone give some input on "Additional Concurrent Pipelines for Lookup Cache Creation" ? I know that this property is used to build caches in a mapping concurently. But which values should I set into this ( i.e. 1 or 2 or 3 or something else ) for concurrent cache building ?

1 Answers   Wipro,


How to go to the older version for a mapping?

0 Answers  


Can we insert and update a target table without using update strategy transformation?How?

4 Answers   Syntel,


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,


What is the difference between a router and a filter transformation?

1 Answers   TCS,


What is souce qualifier transformation it is active or passive

2 Answers   HCL,


Categories