Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

Is there no issue when you try to convert a NOt null column in nullable and vice versa in aggregator styage and transformer stage? When I tried i got the warnings but in a running code I can see such type of scenarios. Please explain

2 Answers  

You enter values in a schema file for RCP and you also entered values in sequential file? which one will it take?

1 Answers   TIAA CREF,

why we use parameters instead of hard code in datastage

4 Answers   HCL,

How to exclude first and last lines while reading data into a sequential file(having some 1000 records).I guess probably by using unix filter option but not sure which to use

6 Answers   IBM,

How to Convert a string function to date function by using only sequential file stage with out using other stages ?

5 Answers   TCS,

Source Like department_no, employee_name ---------------------------- 20, R 10, A 10, D 20, P 10, B 10, C 20, Q 20, S and Output should be like this department_no, employee_list -------------------------------- 10, A 10, A,B 10, A,B,C 10, A,B,C,D 20, A,B,C,D,P 20, A,B,C,D,P,Q 20, A,B,C,D,P,Q,R 20, A,B,C,D,P,Q,R,S

3 Answers  

what is the use of surogate key in datastage

0 Answers   TCS,

how to change left and right links in join stage?

4 Answers   Cap Gemini, IBM,

What are the components of datastage?

0 Answers  

How did you reconcile source with target?

3 Answers   HP,

Can you explain kafka connector?

0 Answers  

What is Horizontal transformation, vertical transformation,diagonal transformation?

2 Answers   Cap Gemini,

For more Data Stage Interview Questions Click Here
Categories