What is sql query override? When did u use sql query override?
Answer / santhosh
sql override is used to write sql select statements
sql override contains in source qualifier transformation
we can use sql override when the source and target are
homogenious database
it will not support flatfiles and hedrogenious database
Is This Answer Correct ? | 6 Yes | 0 No |
explain different types of modeling.
What is the difference between informatica 7.0 and 8.0?
What is informatica? Why do we need it?
After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?
Hi, Steps for upgrading from informatica 7x to 9x or the link which will help me to upgrade from informatica 7 to 9. Regards, Eva
how to identify new and old values in source qualifier or any other transformations using informatica
when we create source as oracle and target as flat file, how can i specify first row as column in flat file?
Major difference between SQL override and Lookup Sql override
Define update strategy?
What is domain and gateway node?
what is incremental loading ?
12 Answers CTS, IBM, Oracle, TCS,
Comment on significance of oracle 9i in informatica when compared to oracle 8 or 8i?