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
- 8089 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / pavani
if we have n duplicates
source---->transformer-------->target.
in transformer we define 2 stage variables
if empno=stg_var2 then stg_var1+1 else 1------->stg_var1;
emp_no-------->stg_var2;
now the constraint for target is stg_var1=2
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Highlight the main features of datastage?
How you can fix the truncated data error in datastage?
what is the custome stage in datastage? how can we impliment that one? plz tell me
How do y read Sequential file from job control?
What are the different plug-ins stages used in your projects?
What is the difference between server job and parallel jobs?
What are the functionalities of link partitioner and link collector?
What are the types of hashed files in data stage
Can you define merge?
Explain entity, attribute and relationship in datastage?
How to RD using transformer?
Differentiate between hash file and sequential file?
Where do the datastage jobs get stored?
Which algorithm you used for your hashfile?
How can we improve performance of data stage jobs?
