What is the exact difference b/w IN and EXIST in Oracle..?
Answer Posted / sujeetha
It is almost similar to IN but the difference is that in
EXIST it will retrive the row atleast one row in the inner
query satisfies but in IN we can have manuy values
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What is domain and gateway node?
What is Cognos script editor?
What are batches?
How to load the data from people soft hrm to people soft erm using informatica?
What is the use of source qualifier?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
Explain scd type 3 through mapping.
Can informatica load heterogeneous targets from heterogeneous sources?
What is confirmed fact in dataware housing?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What are the guidelines to be followed while using union transformation?
Explain the pipeline partition with real time example?
Explain constraint based loading in informatica
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.