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

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

0 Answers   IBM,

How do you load alternate records into different tables through mapping flow?

0 Answers  

task is running successfully but data is not loded why?

2 Answers  

when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?

3 Answers  

How do you manage the Parameter files while migrating your data from one environment to another environment?

0 Answers  




why we need informatica

2 Answers   HCL,

How to configure mapping in informatica?

0 Answers  

How does the aggregator transformation handle null values?

0 Answers  

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

0 Answers   CTS,

hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks... Send me----: raghukrams@yahoo.com

0 Answers  

how remove 1st 3 records & last 3 records in informatics

4 Answers   TetraSoft,

Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

0 Answers  

For more Informatica Interview Questions Click Here
Categories