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
- 1158 Views
- Cap Gemini, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
what is meant by drill through?(Mascot)
Explain about power designer data modeling software?
you have created a lookup transformation for a certain condition which if true returns multiple rows. when you go to the target and see only one row has come and not all. why is it so and how it can be corrected.
Can there be sub steps of etl steps?
What is full load & incremental or refresh load?
if u can't find what you are looking for in lookup table, how do you handle?
how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)
What is fact? What are the types of facts?
list the transformation used for the following:Heterogeneous sources,Homogeneous sources,Find the 5 highest paid employees with in a dept,create a summery table,generate surrogate keys
what is different between sequential batch and concurrent batch and which is recommended and why?
Identifying the bottlenecks in various components of Informatica and resolving them.
What are the steps involved in etl process?
Teradata 
