what is correlated query?
Answers were Sorted based on User's Feedback
Answer / koti
in correlated query is nothing but a sub query, but the difference is sub query can executes first, based on the result the main query executes...
Is This Answer Correct ? | 2 Yes | 1 No |
Can informatica load heterogeneous targets from heterogeneous sources?
what is dimension table?
What are the types of metadata that stores in repository?
How many repositories can we create in Informatica?
How can u insert o ne row in the target if that row does not exists in the target and update if it exists
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
why dimenstion tables are denormalized in nature ?
What is meant by incremental aggregation?
Write the unconnected lookup syntax?
How an expression transformation differs from aggregator transformation?
What is flashback table ? Advance thanks
what is the diff b/w cached and unchaed look ups