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
- 1242 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 reporting tools and difference between them?
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 is virtual Data Warehousing?
In Which Transformation We Can Use Having Clause In Informatica?
how to connect to a flatfile through ftp in informatica
When do we go for the tools in the market?
Is hadoop a etl tool?
Eliminating of duplicate records without using dynamic lookups
What is grain of fact?
What is etl process? How many steps etl contains?
we hava a flat file having more than 1000 records and two targets. i have to write first half of the rows into first targets and next half of rows into second target. how can i do in informetica??
how do u implement unconn.stored proc. in a mapping?
Teradata 
