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
- 6428 Views
- HSBC, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / bhavani
we can acheive this using transformer stage:
1. Check the record count using AGGREGTOR stage and have a column count
2. In the transformer initiate a loop with condition @ITERATION <=count. and loopvar = @iteration
3.if @INROWNUM = loopvar then right(left(@iteration),1) --> output value
Now the result will be 2
5
6
Let me know if this is correct.
| Is This Answer Correct ? | 0 Yes | 2 No |
What is audit table?
How many Nodes configuration file you used in your last project?
how many types of remove the duplicate records?
Notification Activity
what is the use of skid in reporting?
What is the difference between datastage and datastage tx?
What is the difference between Datastage 7.5 and 7.0?
What is the difference between validate and compile?
root tree will find which is server job and which is parallel job?
LIST THE BUILT-IN STAGES AVALIABLE IN SERVER JOBS?
Can you explain players in datastage?
What are data elements?
Teradata 
