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
- 15275 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 a parameter When and where do you them when does the value will be created
what is the process of target load planing?
What is a standalone command task?
Plz can any one say me how to get the informatica certification materials and dumps
What is meta data and system catalog?
What is CHECK-IN CHECK-OUT. Please explane me?
Make a note of the quantity vaults made in informatica?
What is the difference between informatica 8.x and 9.x
What exactly mentioned in High level design document.can somebody explain me sequentialy.
In informatics server which files are created during the session rums?
What is the difference between a router and a filter transformation?
How to use Normalizer transformation?
Teradata 
