Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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.

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

What is the use of incremental aggregation?

2 Answers  


What is the difference between informatics 7x and 8x and what is latest version?

0 Answers  


To import the flat file definition into the designer where should the flat file be placed?

0 Answers   Informatica,


What are the types of caches in lookup?

0 Answers  


How to configure mapping in informatica?

0 Answers  


How many numbers of sessions can one group in batches?

0 Answers  


How to prepared lld.can any one tell me detailed explanetion.

0 Answers   Bank Of America,


What is limitations of truncate and load option

1 Answers   Cap Gemini,


Global and Local shortcuts. Advantages.

0 Answers  


In target table how to display the system time

1 Answers  


what is the need of session partitioning... how it is useful in real time

3 Answers   Amazon,


wht is full process of Information source to target just like stg to productuon and development

1 Answers   Informatica,


Categories