1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

if a column contains data like
abc,aaa,xyz,pwe,xok,abc,xyz,abc,pwe,abc,pwe,xok,xyz,xxx,abc,
roy,pwe,aaa,xxx,xyz,roy,xok....
how to send the unique data to one source and remaining data
to another source????

Question Posted / sourya2009

Answers were Sorted based on User's Feedback



if a column contains data like abc,aaa,xyz,pwe,xok,abc,xyz,abc,pwe,abc,pwe,xok,xyz,xxx,abc, roy,p..

Answer / chandu

S.D sahu answer is correct but don't use transformer stage.

use sort stage and use option as createKeyChangeColumn =
True it allows one virtual key column as keychange column
i.e unique records display as 1 and duplicate records it
give 0 and use simple filter stage and that use option or
give where clause =keychangecolumn=1 . unique records are
went to one dataset and use filter stage stage another
option is output rejects =true duplicate records went to
another dataset.


This is the best answer

Is This Answer Correct ?    21 Yes 1 No

if a column contains data like abc,aaa,xyz,pwe,xok,abc,xyz,abc,pwe,abc,pwe,xok,xyz,xxx,abc, roy,p..

Answer / s.d sahu

First use aggregator stage use rowcount,then use transformer
rowcount=1 to one source rest to another.

Is This Answer Correct ?    5 Yes 6 No

if a column contains data like abc,aaa,xyz,pwe,xok,abc,xyz,abc,pwe,abc,pwe,xok,xyz,xxx,abc, roy,p..

Answer / prasad

by using create key change column is true is disp;ays
duplicates records
if it is false it displays non duplicate records
first keep all the records in sort order

Is This Answer Correct ?    4 Yes 6 No

Post New Answer

More Data Stage Interview Questions

how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

1 Answers  

I have a input as: Col 1 1 2 2 3 I want 3 output as: Output1: 1 1 Output2: 2 2 Output3: 3 i.e. same duplicates should be in one target, other duplicate values should be in another target and so on.. Pls help

9 Answers   IBM,

hi, 1)totally how many jobs created in ur project 2)what is ur datamart size & Dwh size 3)How secure ur project 4)could u plz tell be about testing process after complete the job will run sucessfully or not in Datastage

1 Answers   Wipro,

how can we create tables in datastage?

1 Answers  

how to get the unique records on multiple columns by using sequential file stage only

3 Answers  

I have scenario like this seq file --> transformer --> sort stage --> dataset In this job which prtitioning technique you are using and why???

3 Answers   CTS, IBM,

SOURCE CITY NAME1 NAME2 NAME3 NAME4 BGLR HCL CSC IBM TCS TARGET CITY COMPANY BGLR HCL BGLR CSC BGLR IBM BGLR TCS

1 Answers  

How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...

1 Answers   Alpharithm Technologies,

What is a folder? Difference types of stages?

1 Answers  

1)What is ur project architecture ? 2)how to move project from developement to uat? 3)What is the difference between datastage 6,7.1 and datasttage 7.5? 4).How to do error handling in datastage? 5)3.Whta is unit testing, system testing and integration testing? 6)What is the Exact difference between BASIC Transformer and NORMAL Transformer?When we will go for BASIC Or NORMAL Transformer 7)why we use third party tools in datastage? 8)What is the purpose of Debugging stages? In real time Where we will use?

6 Answers   CTS, HCL, IBM, Wipro,

what r the sources u need to create the datastage?

1 Answers  

diff between changecapture & diffrence stage which situvation we can use the diffrence stage ?

1 Answers   TCS,

For more Data Stage Interview Questions Click Here
Categories