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 diff between Junk dimensions and conform dimension?

4 Answers   Polaris,

in datastage scenario this is sourec data i want this traget? tell me please? source target ------- ------- Mohan,Prasad,Naresh Mohan Prasad Naresh

1 Answers   IBM,

How can we run same job in 1 day 2 times

7 Answers   IBM,

wt is the diff b/w odbc and oracle stage

2 Answers   Accenture, HCL,

i have a small question for datastage, After the desinging (i.e., transformations and loading)part, what we can do?

1 Answers   TCS,

when we have to go for a sequential file stage & for a dataset in datastage?

1 Answers  

how to retrive the max(sal),deptno,empno in datastage?

13 Answers   Polaris,

How to LOG 'unmatched Master' records and 'Reject Updates' in log files using MERGE stage?

1 Answers   TCS,

how can i abort the job if i get more than 100 errors in job log?

6 Answers   Accenture,

Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result as values before the delimiter should come under the column ITEM_CODE and values after the delimiter should come under the column LOC_CODE.. But some datas like "SCH-AS-1010", for this, "SCHAS" should come under the column ITEM_CODE and 1010 should come under the column LOC_CODE.. Pls help me..

1 Answers  

what is the use of surogate key in datastage

0 Answers   TCS,

How to RD using transformer?

0 Answers   CTS,

For more Data Stage Interview Questions Click Here
Categories