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
Can we get 1st record through Informatica(without sequence number).
How do you migrate data from one environment to another?
Explain why we use partitioning the session in informatica?
can u any challenge your project?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Design time, run time. If you don't create parameter what will happen
How can we use batches?
what is Active lock explain
What is the status code in stored procedure transformation?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
Explain sessions. Explain how batches are used to combine executions?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
How to load the data from a flat file into the target where the source flat file name changes daily?
what is song in infrmatica...?
State the limitations where we cannot use joiner in the mapping pipeline?