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

What is the use of datastage director?

0 Answers  

Have you used Unstructured data?

0 Answers   CTS,

what is the definitions for Datawarehose and Datamart?

4 Answers  

Give example for FACTLESS FACT TABLE in real-time scenario.

4 Answers   TCS,

How to read multiple files using a single datastage job if files have the same metadata?

0 Answers  

How one source columns or rows to be loaded in to two different tables?

0 Answers  

how to clear the source file? 2) diff b/t odbc & Oracle?what is node? 3) explain one complex job u face in ur project

2 Answers   Wipro,

I am defining one varaible parameter date in job parameters.I want use this variable date in where clause in source query.

2 Answers   TCS,

can explain wt is the pool for file.

1 Answers   CTS,

i have a scenario with i/p as ID,salary with values 1,1000 2,2000 and 3,4000 i need an extra column in the o/p named amount with values 2000,4000 and NULL. how can i get it?

2 Answers   L&T,

What are some prerequisites for datastage?

0 Answers  

what is the difference between 7.1,7.5.2,8.1 versions in datastage?

3 Answers   IBM,

For more Data Stage Interview Questions Click Here
Categories