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
- 13440 Views
- BirlaSoft, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
How to extract the informatica rejected data?
How can you increase the performance in joiner transformation?
What is the sequence generator transformation in informatica?
What are the new features of informatica 9.x developer?
What is an expression transformation in informatica?
What do you mean by channel change?
What are the types of caches in lookup?
Enlist some properties of sessions.
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What is the benefit of partitioning a session?
If informatica has its scheduler why using third party scheduler?
How you know when to use a static cache and dynamic cache in lookup transformation?
What is a sorter transformation?
