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 we call a stored procedure from a unix script which is run using command task

1 Answers   TCS,

SOURCE NAME SAL GANGA 30000 RAJU 20000 PAVAN 25000 TARGET NAME SAL MAXSAL GANGA 30000 30000 RAJU 20000 30000 PAVAN 25000 30000 in mapping level how to achive that

5 Answers   DELL,

i want to convert below src into target src is as follows maths 30 science 20 social 81 i want data in trg like below maths science social 30 20 81

2 Answers   HCL, HP,

how to we create datamart?

2 Answers   HSBC,

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

0 Answers  




What is rank transformation in informatica

0 Answers   Informatica,

What is the difference between a table and the materialized view?

2 Answers  

hi all, can anyone tell where i will get good informatica training in Pune? thanks in advance.

5 Answers   TCS,

What is a grid in Informatica?

0 Answers  

what is mean by flag 4 in update strategy t/r

6 Answers  

I have the source like col1 col2 a l b p a m a n b q x y How to get the target data like below col1 col2 a l,m,n b p,q x y

2 Answers   DELL,

When to use normalization transformation other than cobol source?

2 Answers  

For more Informatica Interview Questions Click Here
Categories