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

which r the connectors used in san?

0 Answers  

what are the types of nodes

4 Answers   HCL, TCS,

What are the benefits of datastage?

0 Answers  

HOW CAN YOU DO SCD2 IN DATA STAGE USING SEQUENTIAL FILES?

1 Answers   HCL, IBM, Infosys,

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

3 Answers   Deloitte, IBM,

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

4 Answers  

Can you explain kafka connector?

0 Answers  

A flat file contains 200 records. I want to load first 50 records at first time running the job, second 50 records at second time running and so on, how u can develop this job?

1 Answers   TCS,

how can you generate sequence number using only the sequential file stage?

3 Answers   TIAA CREF,

what is data mapping

2 Answers  

can we use sequential file as a lookup

7 Answers   Cognizant, Wipro,

what is the main difference between sorragate key n primary key in one word

2 Answers  

For more Data Stage Interview Questions Click Here
Categories