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
- 1150 Views
- Cap Gemini, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
what is different between sequential batch and concurrent batch and which is recommended and why?
how would u estimate the size of Lookup transform data and index cache?
How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)
0 Answers IBM, Saama Tech, Wipro,
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
Explain what are the various etl tools in the market?
when should one create lookup transformation ?
what is Forward,Reverse and Re_engineering?
how do u decide whether u need to do aggregations at database level or at Informatica level?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
What is partitioning? Explain different types of partitioning?
explain the methodology of Data Warehousing?(Polaries)
Teradata 
