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.

What is power center repository?

1 Answers  

What is the capacity of power cube?

1 Answers  

What are the uses of a Parameter file?

3 Answers   CSC,

when we go for unconnected lookup transformation? and why?

5 Answers   Accenture,

how to we create datamart?

2 Answers   HSBC,

Explain pushdown optimization $pushdownconfig parameter - informatica

0 Answers   Informatica,

what is junk dimension

4 Answers   Cap Gemini,

in mapping i have one source and five targets in that data will be loaded into four targets properily in one target the data is not loaded how will u rectify

3 Answers   Patni,

1 lac of flat fles in source how to load target at a time?

4 Answers   Cap Gemini,

What are the types of lookup caches?

10 Answers   Accenture, IBM, Informatica,

What is dimensional table? Explain the different dimensions.

0 Answers  

When the informatica server marks that a batch is failed?

2 Answers