Home > Software > Data-Warehouse > Informatica
Interview Questions   Tutorials   Discussions   Programs   

Informatica - 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?




574
views
asked marvit September 20, 2014 08:02 AM  

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?


           

1 Answers



 
answered By vishnoiprem   0  
If you ignore to validate sql query in source qualifier transformation mapping validates but at work flow level session fails with as error"variable not in select list.

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 equal to number of rows connected to the next transformation from
source qualifier.
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert