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.
Answer Posted / smith
Only those 4 columns in the sql override will be passed to
the next transformation.
| Is This Answer Correct ? | 2 Yes | 15 No |
Post New Answer View All Answers
What all join we can perform in LOOKUP transformation?
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 to update or delete the rows in a target, which do not have key fields?
What is status code in informatica?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
Explain the code page compatibility?
list out all the transformations which use cache?
What are the components of workflow manager?
What is an expression transformation?
How many ways are there to do 'remove duplicate records in informatica'?
Please let me know how to make encryption and decryption with example?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
Explain the mapping variable usage example in informatica
What are batches?
Why union transformation is an active transformation?