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


Please Help Members By Posting Answers For Below Questions

How to join three sources using joiner?

573


What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

4783


What is the procedure for creating independent data marts from informatica 7.1?

566


What is different between the data warehouse and data mart?

630


What is a joiner transformation and why it is an active one?

580






What is standalone command task?

711


What are the new features of informatica 9.x in developer level?

563


How to generate sequence numbers using expression transformation?

642


Can you use flat files in Mapplets.

2224


Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

1849


How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

709


Mention few advantages of router transformation over filter transformation.

635


In informatica workflow manager, how many repositories can be created?

782


if we have a delimiters at unwanted places in a flat file how can we over come those.

1570


How to load a Dimension ? and how to load a fact table?

955