what is correlated query?

Answers were Sorted based on User's Feedback



what is correlated query?..

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

what is correlated query?..

Answer / ramesh

correlated view is a top down approch

Is This Answer Correct ?    0 Yes 5 No

Post New Answer

More Informatica Interview Questions

i have source as Column1 101 a 101 b 101 c so i want to load target as column1 ---> 101 abc

3 Answers   HP,


As a support project team member, how will you get the questions regarding errors from client or customers (in which format)?

1 Answers  


To import the flat file definition into the designer where should the flat file be placed?

0 Answers   Informatica,


Explain pushdown optimization and types in informatica

0 Answers   Informatica,


i have one senario i have table with 2columns one for primary key another is a constant value(zero). i have to lookup the table and get the maximum primary key here i don't have any common column between source and lookup table(wt table i explained above)... table is (i am assuming he didn't give the table) column1 column2 5 0 2 0 8 0 6 0 3 0 12 0 7 0

2 Answers   TCS,






How to load duplicate records in to a target table which has a primary key?

2 Answers  


How do you load alternate records into different tables through mapping flow?

0 Answers  


How many repositories can be created in informatica?

1 Answers  


What is the way to execute pl/sql script using informatica mapping?

0 Answers  


A Main workflow "wkf_Main" has multiple sessions (S1, S2...., can I make changes and promte one session (S5) at any time or have to promote whole Workflow "wkf_Main" every time?

4 Answers  


I want load the data into target with out 1st and last record.

5 Answers   Yash Technologies,


How to run a session, which contains mapplet?

1 Answers  


Categories