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

Create a job to load all unique products in one table and the duplicate rows in to another table.

The first table should contain the following output

A
D

The second target should contain the following output

B
B
B
C
C

Q2. Create a job to load each product once into one table and the remaining products which are duplicated into another table.

The first table should contain the following output

A
B
C
D

The second table should contain the following output

B
B
C

Question Posted / suneelmanne

Answers were Sorted based on User's Feedback



Create a job to load all unique products in one table and the duplicate rows in to another table. ..

Answer / sudheer

answer for Q2, use sort stage and use generate change key column option. use filter stage to send all change key columns having value=1 to move in to a file which generates A B C D, and filter records having value=0 to another file which generates B B C.

Is This Answer Correct ?    7 Yes 1 No

Create a job to load all unique products in one table and the duplicate rows in to another table. ..

Answer / unknown

Q1: First use Aggregate stage- Row Count property then filter stage to separate Row Count 1 and more than 1.

Is This Answer Correct ?    4 Yes 0 No

Create a job to load all unique products in one table and the duplicate rows in to another table. ..

Answer / nams

It can be done by unix uniq -u file_Name and uniq -d file_Name
or it can be done from datastage sequential file stage filter option from property.....write command overthere like above.....

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More Data Stage Interview Questions

What is size of a transaction and an array means in a datastage?

0 Answers  

i have a table col1 10 20 30 40 10 20 50 my requirement is how to retrive only duplicates like 10 10 20 20 like this how it's possible in SQL?

11 Answers   Cap Gemini,

how to do pergformence tuning in datastage?

4 Answers   MCA, Symphony, TCS,

What is "fatal error/rdbms code 3996" error?

0 Answers  

I have a file it contain 2 records like empname,company as Ram, Tcs and Ram, IBM. But i want empname, company1,company2 as Ram, TCS,IBM in the target. How?

6 Answers   Cap Gemini,

how to find no.of records in sequntial file itself?

4 Answers  

Explain Quality stage?

0 Answers  

how can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction

1 Answers   Reliance,

Differentiate between data file and descriptor file?

0 Answers  

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

3 Answers  

What are the difference types of stages?

0 Answers  

Hi Can any one help regarding below INPUT NAME LOC Ram hyd Ram ban Raj chn Raj Pun Sam del OUPUT NAME LOC Ram Hyd ban Raj chn pun sam del

3 Answers   HCL,

For more Data Stage Interview Questions Click Here
Categories