Interested to Buy Any Domain ? << Click Here >> for more details...
i have a scenario like two columns(Empno, Ename) in that duplicate records are there, so my question is how to get second duplicate record in datastage.
- 4 Answers
- 8303 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / nish
remove duplicate-> retail last
Alternate MEthod: if there are only two occurences then sort stage-> descending-> remove duplicates
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
What is the difference between operational data stage (ods) and data warehouse?
What are the features of datastage flow designer?
How to manage date conversion in Datastage?
What is the use of datastage designer?
Can you implement SCD2 using join, transformer and funnel stage?
Define APT_CONFIG in Datastage?
Distinguish between informatica & datastage. Which one would you choose and why?
Can you explain kafka connector?
Define Merge?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
what is use of SDR function?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
how to add a new records into source?
