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...


Hi

can anyone write query for the below input and output

Table 1
col 1

100
Null
200
300

Table 2
col1

Null
400
700
800

o/p
200
700
800



2)sql

col 1 contains
23x-5-45
26x-12-45
28x-10-50

o/p middlevalue should be greater than 10


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More ETL Interview Questions

Explain etl?

0 Answers  


how would u estimate the size of Lookup transform data and index cache?

1 Answers  


Do we need an etl tool?

0 Answers  


how many steps are there in etl process?

0 Answers  


Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance

0 Answers  


explain the methodology of Data Warehousing?(Polaries)

0 Answers  


what do u do when DB time takes more?in sap bi

0 Answers  


how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.

5 Answers  


when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?

0 Answers  


explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com

0 Answers   Tech Mahindra,


How many types of transformations supported by sorted input?

0 Answers  


what is granularity in Data ware House?

0 Answers   IBM,


Categories