if the column name in sql override is diff from the column name in source qualifier,what is the impact?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / chandu
After over write we have to validate the rewrited query, So
when we click on validate It shows error message.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / kumarapillaietl@gmail.com
We can write any order under SQL query like Oracle SQL part , but the main thing is we need to maintain that query order in our all mapping flow. Else it's error
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
Answer / srinivas
session will fail deu to column name is diff,means select
qry ll select those colomns wch r in table.
Is This Answer Correct ? | 3 Yes | 12 No |
What is substr in informatica?
Explain pushdown optimization and types in informatica
What is the difference between normal and bulk loading? Which one is recommended?
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
What is the role of informatica in project ?Like i showed financial projects?
can we have to do changes in session property when we are dynamically generating target files?
what is the location of parameter file in informatica?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
how can u tune u r informatica mapppings
How to extract sap data using informatica?
we have 6 records in source , i need 2nd record in one target and 5th record in one target or 2nd & 5th record in same target.
what is the method of error handling when session is running?