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
- 8242 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / reddy
Source File/Table--->Transformer-->Target
Transformer stage:
---------------------------
Take two stage variables
sv-->Empno or Ename (drag and drop column(s))
sv1-->if Empno=sv or Ename=sv Then sv1+1 Else 1
in constraint --> sv1=2
u will get second duplicate record
Plz correct me if i am wrong...
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How can one find bugs in job sequence?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
What is the roundrobin collector?
How a server job can be converted to a parallel job?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
What are the types of hashed files in data stage
What are the processing stages?
How to find value from a column in a dataset?
Define Routines and their types?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
What is ds designer?
What are the different options associated with dsjob command?
How will you move hashed file from one location to another location?
What are the repository tables in datastage?
What is the difference between orabulk and bcp stages?
