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
Hi my name is kuldeep singh, i have finished my B.E in computer science and engg in 2008. I have worked with accenture for 17 months and because of family problem i left the job in dec 2009.. i was in data ware housing capability. right now i am working in a BPO as technicla support executive,, i want to move to IT again, please suggest me what shuld i do? its been 1 year gap and i am not able to get into IT...please suggest me ...should i go for informatica certification will that help me to get inot IT. please give ur suggestion..my E mail is is singh.kuldeep2004@yahoo.in
In the SEQ generator which property has to be set to generate seq No. when the input data is more than the max limit.
Explain the key challenges that you face while performing etl testing.
how do u decide whether u need to do aggregations at database level or at Informatica level?
what is the difference between shortcut of an object and copy of an object? compare them?
can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?
what are business components in Informatica?
what is a parameter when and where do u them when does the value will be created. Designing time, run time. If u don't create parameter what will happen?
What is tracing level? How many types of transformations supported by sorted input?
what is a worklet?
What is etl process?
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?