In a table there are 1 million records there in which 3
records are duplicate how will you find out those 3 records?
Answer Posted / vivek singh
select * from emp1
where rowid not in (select max(rowid) from emp1 group by empno);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to create a non-reusable instance of reusable transformations?
How many ways a relational source definition can be updated and what are they?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
Explain transaction control transformation in informatica
Explain sessions?
How to extract the informatica rejected data?
Explain what is informatica metadata and where is it stored?
Tell me about Propagate functions in informatica
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What do you understand by SOA of Informatica?
How we can use union transformation?
How is union transformation utilized?
Make a note of the quantity vaults made in informatica?
What is Session and Batches?
Write the prerequisite tasks to achieve the session partition?