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
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What is the benefit of partitioning a session?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
How many transformations can be used in mapplets.
How do you set a varible in incremental aggregation
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Explain the types of lookup transformation?
What is option by which we can run all the sessions in a batch simultaneously?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
How to do unit testing in informatica?
How can you generate reports in informatica?
Explain the etl program with few examples.
What is sq transformation?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What are the components of workflow manager?