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
- 0 Answers
- 1523 Views
- Cap Gemini, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
what is the difference between normal & bulk loading? and which one is recommended ? why?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
what make u disappointmnets in u r career
Difference between flat files and relational sources?
what is session partitioning?
what are Lookup caches options? Including persistent caches.
Can u access a repository created in previous version of Informatica?
how do u implement scheduling in Informatica?
What is meant by incremental load?
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
What are cubes and olap cubes?
What is a staging area? What is the purpose of a staging area?
Teradata 
