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
What are the types of data warehouses?
What is workflow? What are the components of the workflow manager?
What are the mapping parameters and mapping variables?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What's the layout of parameter file (what does a parameter file contain?)?
What do you understand by SOA of Informatica?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
define galaxy repository in informatica
What you know about transaction control transformation?
whats the logic to load the lower level of granularity of data to fact table.
What is decode in informatica?
Enlist some properties of sessions.
What are the guidelines to be followed while using union transformation?
Implementation methodology
Whats the difference between informatica powercenter server, repositoryserver and repository?