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 / naveen
Above Answer #1 is correct.
Addition of Answer #1 & #2, sql override column order
should be same as source qualifier trnsfn columns.
Regards,
Naveen
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What is confirmed fact in dataware housing?
What are the differences between a connected lookup and unconnected lookup?
Explain informatica architecture - version 8 / 9
What is the difference between source qualifier transformations source filter to filter transformation?
What is the benefit of partitioning a session?
How would you join a node to the already existing domain?
How you know when to use a static cache and dynamic cache in lookup transformation?
According to his methodology what all you need before you build a datawarehouse
Briefly explain the aggregator transformation?
What is the benefit of session partitioning?
Enlist the advantages of informatica.
What will be the approach?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
explain abt ur project architecture?