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 |
write a sql query following table some duplicate present 1 1 2 2 3 3 4 5 i want the output unique one column duplicate another column following format like unique duplicate 1 1 2 2 3 3 4 5
how do u fnd the duplicate rows and how to delete the duplicate rows?
In ur current projectu have done any performance tuning of mappings?
why dimenstion tables are denormalized in nature ?
How to generate sequence numbers?
How can one know that a table has indexes and is partitioned? How data will be pulled from Partitions in Oracle for Informatica?
Why update strategy and union transformations are active? Explain with examples.
explain about unit testing? in real time?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
can a port in expression transf be given the name DISTINCT
how to identify new and old values in source qualifier or any other transformations using informatica
Whats there in global repository