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
- 10081 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
which r the connectors used in san?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
how many rows sorted in sort stage by default in server jobs
What is data partitioning?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
What are stage variables, derivations and constants?
What are the areas of application?
Why we use surrogate key?
What is a quality stage in datastage tool?
Explain usage analysis in datastage?
What is the difference between an operational datastage and a data warehouse?
What is the flow of loading data into fact & dimensional tables?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
describe the Steps to confiure a Qlogic switch
