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

What is etl process? How many steps etl contains?

0 Answers  


what is pmrep command?

0 Answers  


what are the facilities provided by OLAP to analytical users?

1 Answers  


Can we create Hierarchies in generic datasources?

0 Answers   CTS,


what happens if the info.server doesn't find the session parameter in the parameter file?

0 Answers  


what are the reports developed in sap bw project and what is the requirement for developing it?

0 Answers   Maersk,


what is data modeling?

0 Answers  


What are the ETL Testing Operations?

0 Answers  


Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

0 Answers  


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

0 Answers   Cap Gemini,


Compare ETL & Manual development?

0 Answers  


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

1 Answers  


Categories