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
- 9895 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
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
What is ds designer?
What is staging variable?
What are the different options associated with dsjob command?
Why do we use exception activity in Datastage?
What is the difference between datastage and informatica?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
What is the use of hoursfromtime() function in transformer stage in datastage?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
Why we use surrogate key?
What is orabulk stage?
How many Key we can define in remove duplicate stage?
Define meta stage?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
