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
- 8094 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 are data elements?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
How to reverse the string using SQL?
options available in sequence job to run,validate?
How many types of hash files are there?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
Can you define merge?
how many rows sorted in sort stage by default in server jobs
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
What all the types of jobs you developed?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
How can one find bugs in job sequence?
What are the partitioning techniques available in link partitioner?
What is difference between server jobs & parallel jobs?
Define repository tables in datastage?
