if the column name in sql override is diff from the column name in source qualifier,what is the impact?
Answer Posted / s
If the col name is diiferent then too the mapping is valid.
The only condition the no of cols in select stmt and no of
cols in source defn should match. The col values will be
assigned to the particular col name in the order which they
mentioned in the select stmt.
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
In warehouses how many schemas are there?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What is the benefit of partitioning a session?
What are the steps involved in the migration from older version to newer version of Informatica Server?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What is the use of target designer?
How to create a non-reusable instance of reusable transformations?
What is the maplet?
Explain target update override in informatica
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.
What is a passive transformation?
What are the different types of olap? Give an example?
waht type of interface is used for testing the data in informatica
How do we call shell scripts from informatica?