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
When do you use sql override in a lookup transformation?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What is the commit type if you have a transaction control transformation in the mapping?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Write the advantages of partitioning a session?
What is deployment group?
what is diff b/t sorter t/r and agg have the option sorter property...
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
4 yrs etl devloper roles and responsibilities?any body give solutions
Explain about cumulative Sum or moving sum?
Explain target update override in informatica
Have you worked with/created Parameter file
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
Could you explain what is enterprise data warehouse?
How many ways are there to do 'remove duplicate records in informatica'?