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 to extract the informatica rejected data?
Explain what are the different types of transformation available in informatica.
Differentiate between joiner and lookup transformation?
write a query to retrieve the latest records from the table sorted by version(scd)
Differentiate between sessions and batches?
Briefly explain the aggregator transformation?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
How to improve the performance of a session using sorter transformation?
What's the layout of parameter file (what does a parameter file contain?)?
What are mapplets?
Informatica Checkpoints
How many ways are there to do 'remove duplicate records in informatica'?
How union transformation is used?
what are 3 tech challenges/ common issues you face?
How to Create a folder using pmrep command?