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

I have Employee table, 10 cols are connected to next
transformation, only 4 cols are selected in SQL override.
What would be passed to next col.

Question Posted / achoudhr

Answers were Sorted based on User's Feedback



I have Employee table, 10 cols are connected to next transformation, only 4 cols are selected in S..

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......."

Is This Answer Correct ?    19 Yes 1 No

I have Employee table, 10 cols are connected to next transformation, only 4 cols are selected in S..

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.

Is This Answer Correct ?    17 Yes 4 No

I have Employee table, 10 cols are connected to next transformation, only 4 cols are selected in S..

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

Is This Answer Correct ?    3 Yes 0 No

I have Employee table, 10 cols are connected to next transformation, only 4 cols are selected in S..

Answer / achoudhr

Thanks for your reply.

Is This Answer Correct ?    0 Yes 1 No

I have Employee table, 10 cols are connected to next transformation, only 4 cols are selected in S..

Answer / smith

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

Is This Answer Correct ?    2 Yes 15 No

Post New Answer

More Informatica Interview Questions

Can I create one wrkflw which will run different wrkflws on schedule time?

3 Answers  

permutations of mapplet

0 Answers   TCS,

How to delete first 3 rows & last 3 rows in target table in informatica

6 Answers   TetraSoft,

What is a snowflake schema?

0 Answers  

follwing scenario two table using find maximum salary? table a table b 101 xxx 1000 106 6500 103 yyy 5000 108 800 104 din 6000 109 7000 105 dsh 200 110 3000

5 Answers   IBM,




How to generate sequence numbers?

0 Answers  

why normalizer transformation can not used in mapplet? plzzzz answer

2 Answers   Syntel,

what is sql override?what is the use of it?

4 Answers   Sonata,

Tell me about informatica architecture.

2 Answers   TCS,

How can we delete duplicate rows from flat files?

0 Answers  

How can you access the remote source into your session?

1 Answers  

Tell me how many tables used in Ur project and how many fact tables and dimension tables used in ur project

2 Answers   iGate, Qualcomm,

For more Informatica Interview Questions Click Here
Categories