i have a some records
eno ename acono amount
1001 suresh sbi101 12000
1001 suresh sbi101 14000
1001 is dublicata how can i remove duplicate?
Answer Posted / bharathram1234
we can use either rm_duplcte or srt stage..
but if You need any of duplicate record among all other then
u go 4 sort
and if u need last record or first record among all we go 4
rm_duplcte stage.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
What are sequencers?
What is job control?
What is apt_config in datastage?
What is datastage?
What are the primary usages of datastage tool?
sed,awk,head
What are the types of containers in datastage?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
how many rows sorted in sort stage by default in server jobs
Define oconv () and iconv () functions in datastage?
How do you schedule or monitoring the job?
What are routines in datastage?
Where do you see different stages in the designer?