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 / dl
few more addition to the above answer......
If you ignore to validate sql query in source qualifier
transformation mapping validates but at workflow level
sessiom fails with as error"variable not in select
list......."
| Is This Answer Correct ? | 19 Yes | 1 No |
Post New Answer View All Answers
What are the conditions needed to improve the performance of informatica aggregator transformation?
Describe the impact of several join conditions and join order in a joiner transformation?
On which transformations you created partitions in your project?
What is a joiner transformation?
Explain constraint based loading in informatica
What is exclusive and normal mode for repository services?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What are the differences between joiner transformation and source qualifier transformation?
What is the fact table?
Differentiate between Load Manager and DTM?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What all are steps in up gradation of Informatica server?
What is event and what are the tasks related to it?
What is difference between a gateway node and worker node?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me