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

job locking methods? How can we unlock the job?

3 Answers   IBM,

What are the main differences you have observed between 7.x and 8.x version of datastage?

0 Answers  

Hi This is Vijay How Can u Read the data from sequential file Parall'y?

5 Answers   Semantic Space,

ename like ibm,tcs,hcl need display those records only how?

2 Answers  

there are two schemas x and y are there. some data is in x schema. i want to use that in y schema..how can i use? please give some possibilities

2 Answers   Wipro,

where the log files or tables can store in DS?

2 Answers   IBM,

cust id,cust quty like 1,101;1,102;1,103 i want output like cust id,cust quty 1 101,102,103 in oracle please write a query in oracle

3 Answers   TCS,

How to perform incremental load in datastage?

0 Answers  

How to enter a log in auditing table whenever a job get finished?

2 Answers   L&T,

Hi friends, I am new to datastage, i have one query in datastage any one you please give reply to my post. I have a workbook (excel sheet) named as eg: xxxx, in that i have two tables emp(eid, ename, salary, deptno) and dep(deptno, name, state). in my source i have ODBC enterprise stage read the emp table and dept table join the two table and write the dept no 10(eid,ename,salary,name,state) values in target(). Thanks, Badari

0 Answers  

in oracle target stage when we use load option and when we use upsert option?

0 Answers  

what is Audit table?Have u use audit table in ur project?

3 Answers   Accenture, Wipro,

For more Data Stage Interview Questions Click Here
Categories