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
- 10199 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
What are the areas of application?
What is the precedence of stage variables,derivations, and constraints?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
What are the functionalities of link partitioner and link collector?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
How you can fix the truncated data error in datastage?
Name the different types of Lookups in Datastage?
Define Merge?
What are stage variables and constants?
How to perform incremental load in datastage?
what are the devoleper roles in real time? plz tell i am new to datastage....
What are the various kinds of containers available in datastage?
How do you schedule or monitoring the job?
What is a quality stage in datastage tool?
