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 |
How do you load only null records into target? Explain through mapping flow.
How do you recover rows from a failed session
My source is this year 01/jun/2014 04/may/2015 09/mar/2017 my desired output is day month ye 01 jun 2014 04 may 2015 09 mar 2017 how do i acheive this
Suppose we do not group by on any ports of the aggregator what will be the output?
What are the tuning techniques you applied during your last project
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
we have tables like c1 a c2 b c3 c c4 x c5 y and i need output like abcx in a single row and abcy in a single row? how do u do this?
2 Answers Patni, Tech Mahindra,
How do you change parameter when you move it from development to production.
Define Incremental Aggregation?
Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar
How will you display 10-15 letters from a name? (for ex: name="sivasubram'aniam'ramakrishnan". o/p wanted="aniam")
How to extract sap data using informatica? What is abap? What are idocs?