What is sql query override? When did u use sql query override?
Answer Posted / 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 |
Post New Answer View All Answers
Enlist the differences between database and data warehouse.
What is decode in informatica?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
Why filter transformation is an active one?
how tokens will generate?
What is exclusive and normal mode for repository services?
Why do you use Mapping Parameter and mapping variable?
Explain incremental aggregation in informatica
In which transformation you cannot drag ports into it?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Differentiate between source qualifier and filter transformation?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
What is main use of mapplet?