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

i have one table with one column in this column i have three
rows like 1,1,2 then that rows populate to target as first
tow rows as one row and remaing row as one row how it posible?

COLUMN_NAME
SHIVA
RAMU
MADHU

THEN I WANT TO LIKE SHIVA AND RAMU IN ONE ROW AND
MADHU IS ONE ROW IF ANY ONE KNOW PLZ TELL ME

Question Posted / shiva

Answers were Sorted based on User's Feedback



i have one table with one column in this column i have three rows like 1,1,2 then that rows populat..

Answer / srinu

seqfile->sort->transformer->removeduplicate->targer
inser file load
col1
1
1
2
in the sort
key->sort
allowduplicate->true
keychangecolumn->true
in the transformer
create the stage variable
if keychnage=1 then col1 else stagevariablename:col1
drag col1 in transformer
in the derivation area only put stagevariable
remove duplicate:
key:col1
you select last records
we will get answer
col1
11
2

Is This Answer Correct ?    14 Yes 1 No

i have one table with one column in this column i have three rows like 1,1,2 then that rows populat..

Answer / prasad

Question is not clear.

U want 1,1 records goes to one target and duplicate records goes to another target, is it right? can u plz conform this and just let me know?

Is This Answer Correct ?    0 Yes 0 No

i have one table with one column in this column i have three rows like 1,1,2 then that rows populat..

Answer / raj

Use a pivot stage

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Data Stage Interview Questions

How To find the location of APT_confid file

2 Answers   CTS,

Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result "SCH-AS" in onee column and "1010" in another column.. Can any one tell the answer...

5 Answers  

i have flat file and using unix how can i generate sequence number into targer?

1 Answers   Cap Gemini,

What is a quality stage?

1 Answers  

input Name Salay Sam 10 Sam 30 Sam 20 Ram 40 Ram 50 Output should be Name Salary Count Sam 10 3 Ram 40 2 get min salary and count of name . OutPut 2 Name Seq Sam 1 Sam 2 Sam 3 Ram 1 Ram 2

1 Answers   HCL,

convert yyyy mm dd to dd mm yyyy?

4 Answers  

why dataset ?

2 Answers  

by using dsjob..we can run only one job at a time?how can u run multiple jobs at a time in unix?

1 Answers  

country, state 2 tables r there. in table 1 have cid,cname table2 have sid,sname,cid. i want based on cid which country's having more than 25 states i want to display?

3 Answers   Wipro,

What is ds designer?

0 Answers  

How do y read Sequential file from job control?

2 Answers   HP, IBM, Telesis,

I have load a Dataset in UAT with 2 Node configuration, imported the job into PROD environment which is 4 node configuration and using this DataSet as SRC to other job. will the job run fine or give any errors? If job runs fine, on how many nodes? 2 nodes or 4 nodes?

2 Answers   TCS,

For more Data Stage Interview Questions Click Here
Categories