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
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 |
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 |
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 |
what are the enhancements made to Informatica 7.1.1 version when compared to 6.2.2 version?
How to generate sequence numbers using expression transformation?
Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar
what type of documents you receiving from client later wt can you do? what type of documents have to prepare?
What are the components of Informatica? And what is the purpose of each?
Briefly explain the aggregator transformation?
how do u move the code from development to production?
On a day i load 10 rows in my target and on nextday i get 10 more rows to add in target. But out of 10 - 5 records are send them to target?how i can insert the remaining records
what transformations are used for Variable port?
guys which is the best institute in banglore to learn informatica??
What is repository manager?
what type of problem you faced insales project or insurance project