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.
- 5 Answers
- 15029 Views
- BirlaSoft, I also Faced
- E-Mail Answers
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 is the use of incremental aggregation?
What is the difference between informatics 7x and 8x and what is latest version?
To import the flat file definition into the designer where should the flat file be placed?
What are the types of caches in lookup?
How to configure mapping in informatica?
How many numbers of sessions can one group in batches?
How to prepared lld.can any one tell me detailed explanetion.
What is limitations of truncate and load option
Global and Local shortcuts. Advantages.
In target table how to display the system time
what is the need of session partitioning... how it is useful in real time
wht is full process of Information source to target just like stg to productuon and development
Teradata 
