Interested to Buy Any Domain ? << Click Here >> for more details...
how can i get 2nd highest salary in datastage?can u send me
,thanQ
2)if i had source has 2 records 1st record ie 1st column
contains 1,2,3 and 2nd coulmn contains 10,10,10 i have to
get target as 2nd columns as 20,30,40 how can i?
- 3 Answers
- 23706 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / subhash
for 2nd Qn:
Source is:
Col1 Col2
1 10
2 10
3 10
In transformer, we put the below logic:
Link.Col1 * Link.Col2 + Link.Col2------>Col2
1*10+10------------->20
2*10+10------------->30
3*10+10------------->40
Hope this is fine.
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
Which commands are used to import and export the datastage jobs?
Differentiate between validated and Compiled in the Datastage?
What is the difference between datastage and datastage tx?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
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
What is merge stage?
How do you start developing a datastage project?
Can you explain link buffering?
What are transforms and what is the differenece between routines and transforms?
How a routine is called in datastage job?
What is the flow of loading data into fact & dimensional tables?
How do you reject records in a transformer?
What is the method of removing duplicates, without the remove duplicate stage?
