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
What is etl process? How many steps etl contains?
what is pmrep command?
what are the facilities provided by OLAP to analytical users?
Can we create Hierarchies in generic datasources?
what happens if the info.server doesn't find the session parameter in the parameter file?
what are the reports developed in sap bw project and what is the requirement for developing it?
what is data modeling?
What are the ETL Testing Operations?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
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
Compare ETL & Manual development?
how would u estimate the size of Lookup transform data and index cache?