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 |
What is a shortcut and copy in Informatica and how two are different with each other?
Is it any possible to using more than one port in Unconnected Lookup Transformation( :LKP.LKP_Prod(Prod_GRP ,Prod_DT,Prod_TM) ) Like this? Pls explain...
Is it possible to update the target table with PK?
What is the Difference between SetVariable and setmaxvariable in informatica?
I have scenario, i have 10 worklflows and i want run the 1st workflow first and immediately i want to run 10th workflow has to run and am not bothering of 2 to 9 workflows? can any one help me how to do this? Thanks in advance.....
why union transformation is active transformation?
Differences between version 7.x and 8.x.
0 Answers Accenture, Cognizant,
What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.
Where can we find the throughput option in informatica?
when will we go for unconnected lookup transformation in Informatica?
How could we generate the sequence of key values without using sequence generator transformation in the target ??
12 Answers TCS, Tech Mahindra,
How to jion 2 tables, without using any condition?