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
- 23548 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
What is a ds designer?
What are the areas of application?
What is the difference between an operational datastage and a data warehouse?
which r the connectors used in san?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
Explain how a source file is populated?
What are the important features of datastage?
What are the components of datastage?
Describe link sort?
What is a merge in datastage?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
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?
How to perform incremental load in datastage?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
