How we can get unique records into one target table and
duplicate records into another target table??
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 are junk dimensions?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Explain the informatica workflow?
Explain constraint based loading in informatica
How does a rank transform differ from aggregator transform functions max and min?
Explain the shared cache and re-cache?
Why update strategy and union transformations are active? Explain with examples.
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What is depict expression change?
How do you update the records with or without using update strategy?
Briefly define reusable transformation?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What is the benefit of partitioning a session?
Explain your project of banking domian.
Whats the difference between informatica powercenter server, repositoryserver and repository?