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
- 6308 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 |
How do you import and export the datastage jobs?
Hi guys, 7. how to get this output i/p col1,col2 101,a 102,b 103,c 104,d o/p col1,col2 101,d 102,c 103,b 104,a Thanks
country, state 2 tables r there. in table 1 have cid,cname table2 have sid,sname,cid. i want based on cid which country's having more than 25 states i want to display?
What are the areas of application?
State the difference between an operational datastage and a data warehouse?
Tell me the syntax of Configuration file?
how to configure databases through datastage
Can you explain kafka connector?
How many nodes supported by a one cpu in parallel jobs?
How many types of views are there in a datastage director?
Hi This is Vijay How Can u Read the data from sequential file Parall'y?
How can we select pr retrieve the particular row in dataset by using orchadmin command?
Teradata 
