Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?

Answers were Sorted based on User's Feedback



input like 2 7 8 9 5 1 7 3 6 output:2 5 6 how to find out this plz explain?..

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

input like 2 7 8 9 5 1 7 3 6 output:2 5 6 how to find out this plz explain?..

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

Post New Answer

More Data Stage Interview Questions

deptno wise to find max and min,and sum of rows and in target to company wise maximum

1 Answers   IBM, TCS,


Describe the architecture of datastage?

0 Answers  


How did you reconcile source with target?

3 Answers   HP,


What is the use of Row generator stage?

2 Answers  


In a table 100 records are there after 50records job is aborted how can u insert all records in target table.

1 Answers   Cap Gemini,


HOW CAN WE SEE THE DATA IN DATASET?

4 Answers  


what is diff b/w datastage 8.1,8.5,8.7?

1 Answers   IBM,


Wat is isolation level and when do u use them?

1 Answers   HP, IBM,


WHERE YOU USE UNIX COMMANDS AS A ETL DEVELOPER?

2 Answers   Wipro,


What is RCP

5 Answers   CGI, CTS,


What is a range lookup?

2 Answers   IBM,


what is advantages of snowflake when it is used?

3 Answers   IBM,


Categories