1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

After draging the ports of three sources(sql
server,oracle,informix) to a single source qualifier, can
you map these three ports directly to target?

Question Posted / swetha

Answers were Sorted based on User's Feedback



After draging the ports of three sources(sql server,oracle,informix) to a single source qualifier, ..

Answer / kanth

Here they are having Heterogeneous sources how can those
can be joined at source quaifier.i think the question is
not clear u cannot darg the three heterogeneous siurces to
sinle source qualifier

Is This Answer Correct ?    6 Yes 0 No

After draging the ports of three sources(sql server,oracle,informix) to a single source qualifier, ..

Answer / atiric software(raja)

we cannot join haterogeneous sources in the s.q so we
cannot map those ports to target directly if we want we must
use the joiner transformation

Is This Answer Correct ?    5 Yes 0 No

After draging the ports of three sources(sql server,oracle,informix) to a single source qualifier, ..

Answer / bidhar

You cannot join Hetrogeneous sources in a SQ.For that you
need use joiner.For example if you have n hetrogeneous
sources then you must use n-1 joiners.

Is This Answer Correct ?    3 Yes 0 No

After draging the ports of three sources(sql server,oracle,informix) to a single source qualifier, ..

Answer / madhukar

We cant perform heterogeneous sources with sqt.

Is This Answer Correct ?    2 Yes 0 No

After draging the ports of three sources(sql server,oracle,informix) to a single source qualifier, ..

Answer / swetha

NO.Unless and until u join those three ports in source
qualifier you cannot map them directly.

Is This Answer Correct ?    1 Yes 1 No

After draging the ports of three sources(sql server,oracle,informix) to a single source qualifier, ..

Answer / eric yang

To Swetha,
I am afraid these 3 ports have been joined already in source
qualifier, and therefore can map directly to a target, why not?

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More Informatica Interview Questions

What are the different threads in DTM process?

1 Answers  

What is domain in terms of informatica?

0 Answers  

How many dimensions are there in informatica?

0 Answers  

i have 2 mapings for this 2 mapings i want use only one lookupt/r how?

3 Answers   Wipro,

What are the new features of informatica 9.x at the developer level?

0 Answers  




Why we use lookup transformations?

1 Answers  

difference between stop and abort

2 Answers  

What are the challenges of Dataware housing in the future?

2 Answers   HP,

What are the types of caches in lookup? Explain them.

0 Answers  

task is running successfully but data is not loded why?

2 Answers  

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

0 Answers   CTS,

What is meant by pre and post session shell command?

0 Answers  

For more Informatica Interview Questions Click Here
Categories