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
- 1144 Views
- Cap Gemini, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
Hi, I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.
Difference between flat files and relational sources?
what is the difference between OLTP database and data warehousing database?
What is the difference between project backlog and product backlog?
what is the difference between cubes and package in cognos
what are the production issues in datastage?
What is cube grouping?
what are the parts of Informatica server ?
HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com
What are materialized views & where do we use them?
flat filevalidation in informatica
Eliminating of duplicate records without using dynamic lookups
Teradata 
