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.
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
What is datastage engine?
Explain entity, attribute and relationship in datastage?
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
What is difference between join, merge and lookup stage?
Distinguish between informatica & datastage. Which one would you choose and why?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
Differentiate between hash file and sequential file?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
how to sort two columns in single job in datastage.
Name the different types of Lookups in Datastage?
What are the different plug-ins stages used in your projects?
How do you reject records in a transformer?
Why we use surrogate key?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
Lookup constraints