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 can u execute the sql query through unix? What is the Primary key for Dimension table? what is the primary key for Fact table?

5 Answers   TCS,

In my source i have 10 records but i want 11 records in target. How can i acheive this in Server jobs.

2 Answers   IBM,

Hi dude, i/p eno ename date edate deptno 1 x 10thjuly 30july A 2 y 10th aug 30 aug B 1 x 1aug ------ A 3 z 1jan ------ c 2 y 1sep ------ B o/p is eno ename date edate deptno 1 x 1aug ------ A 2 y 1sep ------ B 3 z 1jan ------ c Here edate is System generates we don't know that value. Please design the job by using SCD stage and Sql query. If any body know this answer please tel me. Tanks.

1 Answers   Amdocs,

What is audit table?

1 Answers  

HOW CAN WE SEE THE DATA IN DATASET?

4 Answers  

What are some prerequisites for datastage?

0 Answers  

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,

How many number of reject links merge stage can have?

7 Answers   TCS,

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

13 Answers   Polaris,

Why do we use exception activity in Datastage?

0 Answers  

How can we improve performance of data stage jobs?

0 Answers  

What is active and passive stage?

0 Answers  

For more Data Stage Interview Questions Click Here
Categories