Answer / anil

Hi,

This can be do easily with loops in transformer stage

Design 
--------
Sq File - > Aggregrate - > Transformer - > Unique
                                |
                              Duplicate

1. In aggregate, calculate no of rows say counts
2. In transformer , define a stage variable stgTest whose derivation is if counts > 1 then 'Duplicate' Else 'Single'
3. In the loop condition define @iteration < Counts
4. Take a loop variable saying lopNumbers = EID
5. Now for Unique link write constraint as stgTest = 'Single' and output derivation of EID = @iteration.
6. Now for Duplicate link write constraint as stgTest = 'Duplicate' and output derivation of EID = @iteration.
7. Now you will get duplicate values in one link and unique values in another link.

Answer / sreenu

Using aggregation and filter stage,
In aggregation stage we calculate the count of incoming
records and in filter we use count<>1 for output1, count=1 for
output2...

Answer / vsandu

just sort the data ,and bring key changevalues by using
sort ,
in transformer write a logic if group id is 1,0 then target
1 else if group id is anly 1 then target2

as per my knowledge ,if any mistake correct me

Can you highlight the main features of ibm infosphere information server?

0 Answers  

---

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

0 Answers  

---

source file contains 100 records, i want 10 records in target file how it possible in datastage

6 Answers   IBM,

---

How many types of sorting methods are available in datastage?

0 Answers  

---

in sequtial file 2 columns avaliable,iwant only one column load the target how do it.

10 Answers   Wipro,

---

How to remove duplicates in transformer stage? in parallel mode

6 Answers   Syntel, TCS,

---

whom do you report?

0 Answers   NTT Data,

---

What is the difference b/w Hash file and Lookup Fileset stages?

1 Answers  

---

Wat is isolation level and when do u use them?

1 Answers   HP, IBM,

---

while we using change capture stage we have to be take two table thats are 1.before table 2. after table . what is before table and after table please give me clear notation Thank You very much in advance

2 Answers   MGL,

---

In my previous project we get data from mainframe and load it into datastage DB2 tables.Sometimes we get data as flat file or a mainframe tables itself directly we fetch the data.Is this a migration project?

1 Answers   TCS,

---

Can you explain how could anyone drop the index before loading the data in target in datastage?

0 Answers  

---