If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks
7 10815Can any one give me an example for factless fact table ? If your answer is studunt attendence registration,could you plese give me explanation for this ?
3 10744select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?
5 9138Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
2245How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks
2 6943How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)
6 10467Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation
1 14524In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?
4 9568Post New Puma Interview Questions
What is color forecasting?
Given an array of 1s and 0s arrange the 1s together and 0s together in a single scan of the array. Optimize the boundary conditions?
Is spring only for java?
Explain update statistics.
How is it possible to use the host value and not ip address or the dns name for a tcp input?
What kind of systems can be motorized with rpa ( blue prism )?
What is the incorrect declaration of a set?
To whom a method is accesssed if it is marked as protected internal ?
how can we determine size of a cable by knowing the kw or current rating of a load?how can we calculate the resistance box of a slip ring motor?
How the service module works in CRM?
Explain what is progress payment?
In single phase ac ups supply when current is measured with tong tester neutral current is found more than phase current.What is the reason?
What are special characters c++?
What are linear and non-linear systems?
Can you interact with clients?