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
What is the scenario which compels informatica server to reject files?
How to configure mapping in informatica?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Which transformation should we use to normalise the COBOL and relational sources?
Explain sessions. Explain how batches are used to combine executions?
How can we delete duplicate rows from flat files?
Explain the code page compatibility?
What are the types of schemas we have in data warehouse.
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What do think which one is the better joiner or look up?
How to join three sources using joiner?
What is domain in terms of informatica?
Define update strategy?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
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