write a query for how to eliminate the duplicate rows
without using distinct?
Answer Posted / madhu
DELETE FROM EMP WHERE ROWID NOT IN (SELECT MAX(ROWID)FROM
EMP GROUP BY EMPNO);
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
what is the size ur source like(file system or database)? how many record daily come u r banking project?
How to update a particular record in target with out running whole workflow?
How to call shell scripts from informatica?
What is native users?
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
What are the tasks that source qualifier perform?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What are the guidelines to be followed while using union transformation?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Enlist some properties of sessions.
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What are active and passive transformations?
What is incremental aggregation?
What is meant by target load plan?
How to improve the performance of a session using sorter transformation?