Answer / dl

few more addition to the above answer......

If you ignore to validate sql query in source qualifier
transformation mapping validates but at workflow level
sessiom fails with as error"variable not in select
list......."

Answer / dl

no rows from the source qualifier transformation.It gives
an error like" query should return exactly 10 fields to
match fields projected from the source qualifier." .
Because number of rows selected in sql override must eqal
to number of rows connected to the next transformation from
source qulifier.

Answer / naveen

Above Answer #1 is correct.

Addition of Answer #1 & #2, sql override column order
should be same as source qualifier trnsfn columns.

Regards,
Naveen

Answer / achoudhr

Thanks for your reply.

Answer / smith

Only those 4 columns in the sql override will be passed to
the next transformation.

How mapping parameter and variable works

1 Answers  

how many types transformations supported by sortedinput?

4 Answers  

hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks...

0 Answers  

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

0 Answers   IBM,

How to find from a source which has 10,000 records, find the average between 500th to 600th record?

3 Answers  

Do you have to change the reject file b4 using reject loader utility.

1 Answers  

What is junk dimention?

3 Answers   Patni,

what transformations are used for Variable port?

2 Answers  

How to call stored Procedure from Workflow monitor in Informatica 7.1 version?

1 Answers   Accenture,

Where do you create/define mapping parameter and mapping variable?

1 Answers  

what is the difference between copy object import objects using repositery manager which one is best

1 Answers   TCS,

Can we run session without using workflows?

5 Answers   TCS,