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
- 1477 Views
- Cap Gemini, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
what is pmrep command?
where is the cache (lookup, index) created and how can you see it.
how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
What are the various tools used in etl?
Can we parametrize the values of IN statement. Ex. Inside parameter file: Parameter='A','B','C' Inside Code: IN (INPUT_CHARACTER, $$Parameter)
What are the steps involved in etl process?
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
What do you understand by the term ‘transformation’?
how do u implement configuration management in Informatica?
explain the methodology of Data Warehousing?(Polaries)
without using ETL tool can u prepare a Data warehousing and maintaining?
Teradata 
