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 the use of materialized view?

0 Answers   CTS,

how can we do null handling in sequential files

2 Answers   Reliance,

Hi Vijay here For Four CPU's how many nodes will required?

4 Answers   TCS,

How to lode data in sequntional files perform faster?

1 Answers   Polaris,

How and where you used hash file?

0 Answers  

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

1 Answers   IBM,

Have you have ever worked in unix environment and why it is useful in datastage?

0 Answers  

How many jobs in ur project? Explain any complex job u have done in ur project?

1 Answers   IBM, TCS,

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

0 Answers   Wipro,

What is difference between server jobs & parallel jobs?

0 Answers  

I have 2 files 1st contains duplicate records only, 2nd file contains Unique records.EX: File1: 1 subhash 10000 1 subhash 10000 2 raju 20000 2 raju 20000 3 chandra 30000 3 chandra 30000 File2: 1 subhash 10000 5 pawan 15000 7 reddy 25000 3 chandra 30000 Output file:--&#61664; capture all the duplicates in both file with count. 1 subhash 10000 3 1 subhash 10000 3 1 subhash 10000 3 2 raju 20000 2 2 raju 20000 2 3 chandra 30000 3 3 chandra 30000 3 3 chandra 30000 3

2 Answers   TCS,

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

0 Answers  

For more Data Stage Interview Questions Click Here
Categories