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
Answers were Sorted based on User's Feedback
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 |
Can you explain engine tier in information server?
CAN ANY ONE TELL ME THE ARCHITECTURE OF DATASTAGE CLEARLY....
What are the processing stages?
i/p 1,a,1000 2,b,2000 3,c,3000 i want to get o/p as o/p 1,a,3000 2,b,4000 3,c,5000 how it can be done on using datastage?
in job of 30 one job is very slow due to this entire job is very slow how can u know which job is slow?
Differentiate between data file and descriptor file?
I have 3 jobs A,B and C , which are dependent each other. I want to run A & C jobs daily and B job run only on sunday. how can we do it?
Give example for FACTLESS FACT TABLE in real-time scenario.
how do u catch bad rows from OCI stage? And what CLI stands for?
What are the different types of lookups in datastage?
What are data elements?
Name the different types of Lookups in Datastage?