If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks
7 8220Can 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 9298select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?
5 7376Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
1753How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks
2 5987How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)
6 8535Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation
1 13348In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?
4 7890Post New Puma Interview Questions
What is a command to stop and start dmgr?
Do you know what is application?
What is the difference between session and viewstate?
What is self referencing foreign key?
In simple terms, what is the internet of things?
Explain more about the Test Fusion Report of QTP?
Which are the two components of bayesian logic program?
Define about obj-open method?
Tell me how symbol is different from variables?
In accounting, are assets a permanent account?
How is shadow dom helping angular 2 to perform better?
What is function and procedure?
What can’t we put into an array or dictionary?
What are your views on the cashless economy?
Why concurrenthashmap is fail safe?