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
- 7089 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
Can you explain engine tier in information server?
What are the areas of application?
Define oconv () and iconv () functions in datastage?
What is difference between symmetric multiprocessing and massive parallel processing?
What are the types of jobs we have in datastage?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
What are the different options associated with dsjob command?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
How a server job can be converted to a parallel job?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
What are the important features of datastage?
What are the steps needed to create a simple basic datastage job?
Differentiate between hash file and sequential file?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
What are stage variables and constants?
