Interested to Buy Any Domain ? << Click Here >> for more details...
How we can get unique records into one target table and
duplicate records into another target table??
- 11 Answers
- 41295 Views
- Deloitte, IBM, iGate, I also Faced
- E-Mail Answers
Answer Posted / naveen
Answer #3 is correct by Nag.
Addition to above second query for duplicate records, will
return unique records for each duplicate records.
if you need all duplicates records thn follow the below
query.
select * from emp
where empno in (select empno from emp group by empno having
count(empno)>1)
Regards,
Naveen
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
What does update strategy mean, and what are the different option of it?
Explain informatica architecture - version 8 / 9
What is blocking transformation?
What is workflow monitor?
What are the designer tools for creating transformations?
What is the session task and command task?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is a mapplet/worklet in informatica?
What are Dimensional table?
Can you use flat files in Mapplets.
Separate from an archive server and a powerhouse?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What is the command used to run a batch?
is it possible to index the data in cache of lkp transformation ?
How is union transformation utilized?
