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 lode data in sequntional files perform faster?

1 Answers   Polaris,

Explain usage analysis in datastage?

0 Answers  

What are the functionalities of link collector?

0 Answers  

i/p o/p1 o/p2 1 1 4 1 1 5 1 1 6 2 2 2 2 2 2 3 3 4 5 6 how to populates i/p rows into o/p1&o/p2 using datastage stages?and also the same scenario using sql?

8 Answers   IBM,

How do you register plug-ins?

0 Answers  

what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees

0 Answers  

what is the difference between 7.1,7.5.2,8.1 versions in datastage?

3 Answers   IBM,

in sequtial file 2 columns avaliable, i want only one column load the target. for this we can do by modify and copy stage. But here when using modify stage (in property drop column1) until it is ok. if target is data set How to view the data. with out using data management. what is the reason for this. if any body know this answer plz tel me. thanks.

1 Answers   IBM,

how to find diff between 2 dates without using Icon... funtions?

1 Answers  

What are the enhancements made in datastage 7.5 compare with 7.0?

0 Answers  

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

4 Answers  

Can you explain kafka connector?

0 Answers  

For more Data Stage Interview Questions Click Here
Categories