Answer / 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...

Answer / 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

Answer / narasimha rao k

By using Removeduplcate stage in datstage

This stage having avalabel Removeduplicate 1st and last you select last automatically apply to second duplicate data

Answer / nish

remove duplicate-> retail last

Alternate MEthod: if there are only two occurences then sort stage-> descending-> remove duplicates

how to design the change capture stage in(data stage parallel jobs) type 2

2 Answers   IBM,

---

1)i put Pharma Project in my Resume..whar are the sources used in my project Generally? 2)how many fact and dimensional tables used? 3)Have u used any Datamarts and measues in fact table? ....plz give the answers...

2 Answers   iGate,

---

What is the default padding character?

3 Answers   IBM,

---

Explain usage analysis in datastage?

0 Answers  

---

What is PX?

2 Answers   IBM,

---

what is flow of project?

0 Answers   HSBC, IBM,

---

What is RCP?

2 Answers   TCS,

---

Suppose take my name "Reddyvaraprasad" From source it is coming Reddy vara prasad Need to get As Reddyvara prasad/

4 Answers   TCS,

---

hi All, i have one scenario like if source--->transformer-->2 target sequential files the 1 st target sequential file is loads the data from source and 2nd target sequntial file contain the 1st target total record count,and file name of 1 st target seq file and timestamp seperated by delimeter for example if source have 10 record the 1st target seq file hav 10 records and 2nd target seq file example 10|xyz.txt|20101110 00:00:00 could you please help me out how can i implement in datastage job.

4 Answers   IBM,

---

3) Sequential file contains data like Empno ename sal 111 abc 2000 Trgt file: Trgt1----111 Trgt2----abc Trgt3---2000

2 Answers  

---

Describe link sort?

0 Answers  

---

How you Implemented SCD Type 1 & Type 2 in your project?

0 Answers  

---