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 is the gap analysis?

1 Answers  

What is a surrogate key?Why we use it in a mapping?Pl give an example.

4 Answers   PCS,

Why update strategy and union transformations are active?

0 Answers  

what is dynamic cashe

3 Answers   Informatica,

In which transformation you cannot drag ports into it?

0 Answers   Informatica,




Tell me one complex query in oracle ?

2 Answers   L&T, Satyam,

What are active transformations? Name them.

1 Answers  

HOW CAN U FIND THE SESSION START TIME? chandumba2005@gmai.com

2 Answers   TCS,

What does update strategy mean, and what are the different option of it?

0 Answers  

can we use cartesian join in informatica

3 Answers   IBM,

Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?

2 Answers   TCS,

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

3 Answers   Wipro,

For more Informatica Interview Questions Click Here
Categories