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
- 15227 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
What is a passive transformation?
How would you join a node to the already existing domain?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What are the differences between oltp and olap?
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 you know when to use a static cache and dynamic cache in lookup transformation?
What is Index Caches size?
What are session parameters ? How do you set them?
Repository user profiles
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How is union transformation utilized?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
what is the Default Source Option For Update Strategy Transformation?
what is the hint? how to use it to reduce the query processing in program?
