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

Hi my name is kuldeep singh, i have finished my B.E in computer science and engg in 2008. I have worked with accenture for 17 months and because of family problem i left the job in dec 2009.. i was in data ware housing capability. right now i am working in a BPO as technicla support executive,, i want to move to IT again, please suggest me what shuld i do? its been 1 year gap and i am not able to get into IT...please suggest me ...should i go for informatica certification will that help me to get inot IT. please give ur suggestion..my E mail is is singh.kuldeep2004@yahoo.in

0 Answers  


In the SEQ generator which property has to be set to generate seq No. when the input data is more than the max limit.

3 Answers   Accenture,


Explain the key challenges that you face while performing etl testing.

0 Answers  


how do u decide whether u need to do aggregations at database level or at Informatica level?

1 Answers   QualTech,


what is the difference between shortcut of an object and copy of an object? compare them?

1 Answers  


can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?

0 Answers  


what are business components in Informatica?

2 Answers  


what is a parameter when and where do u them when does the value will be created. Designing time, run time. If u don't create parameter what will happen?

1 Answers  


What is tracing level? How many types of transformations supported by sorted input?

0 Answers  


what is a worklet?

0 Answers  


What is etl process?

0 Answers  


how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?

0 Answers  


Categories