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
What is the meaning of decode in informatica?
If informatica has its scheduler why using third party scheduler?
How union transformation is used?
What happens when a session fails and you click on recover?
What are the different versions of informatica?
How do you load only null records into target?
What is the session task and command task?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Why is sorter an active transformation?
what is size of u r database?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
server hot-ws270 is connect to Repository B. What does it mean?
Explain what transformation and how many are there in informatica?
What is a filter transformation?
How do you take back up of repository?