Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3 Answers
- 9941 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
Could anyone give brief explanation bout datastage admin
How to perform incremental load in datastage?
What are the components of datastage?
Where do the datastage jobs get stored?
How do you import and export the datastage jobs?
how do u catch bad rows from OCI stage? And what CLI stands for?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
table actions available in oracle connector?
Describe link sort?
Differentiate between Join, Merge and Lookup stage?
what is use of SDR function?
Differentiate between hash file and sequential file?
How do you run datastage job from the command line?
