Interested to Buy Any Domain ? << Click Here >> for more details...
input like
2 7 8
9 5 1
7 3 6
output:2 5 6 how to find out this plz explain?
- 2 Answers
- 6266 Views
- HSBC, I also Faced
- E-Mail Answers
Answer Posted / deepanshu
supposing single column is there having values
278
951
736
sol'n :
Use transformer string function with @inrownum variable.
inputcolumn[@inrownum,1]
will give you desired o/p
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Name the third party tools that can be used in datastage?
What are the components of datastage?
On which interface you will be working as a developer?
How to RD using transformer?
Nls stands for what in datastage?
what is flow of project?
How rejected rows are managed in datastage?
What are orabulk and bcp stages?
How you can fix the truncated data error in datastage?
What is the use of datastage director?
Can you explain how could anyone drop the index before loading the data in target in datastage?
What is the difference between hashfile and sequential file?
Differentiate between datastage and datastage tx?
What is a folder? Difference types of stages?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
