if the column name in sql override is diff from the column name in source qualifier,what is the impact?

Answer Posted / suman

if the coloumn name is different in sql override and in the
source qualifier it throws the error invalid identifier

Is This Answer Correct ?    0 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the scenario which compels informatica server to reject files?

850


How to configure mapping in informatica?

928


Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2150


Which transformation should we use to normalise the COBOL and relational sources?

984


Explain sessions. Explain how batches are used to combine executions?

804


How can we delete duplicate rows from flat files?

988


Explain the code page compatibility?

855


What are the types of schemas we have in data warehouse.

743


I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

1812


What do think which one is the better joiner or look up?

994


How to join three sources using joiner?

834


What is domain in terms of informatica?

790


Define update strategy?

835


How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1556


5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1686