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
How would you copy the content of one repository to another repository?
Clarify the aggregator change?
What are the prerequisite tasks to achieve the session partition?
Differentiate between a database and data warehouse?
What is the procedure for creating independent data marts from informatica 7.1?
How would you join a node to the already existing domain?
What does update strategy mean, and what are the different option of it?
Explain the types of transformations?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Enlist the tasks for which source qualifier transformation is used.
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
How union transformation is used?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What are the types of caches in lookup? Explain them.
How can we remove the duplicates from flat file source?