If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks
7 10450Can 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 10503select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?
5 8830Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
2154How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks
2 6785How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)
6 10144Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation
1 14357In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?
4 9301Post New Puma Interview Questions
Where is the iis manager in windows 10?
Where are last ran status can be seen?
What is c++ map?
Which planet in our solar system has the most circular orbit?
What is the Final availability and how can change availability of Rule?
Is microsoft access available in office 365?
what is tracing? Where it used?
Why is mongodb?
Tell us the difference between merge and quick sort. Which one would you prefer and why?
What are cosmic rays?
Is java 9 released?
Write the components microstrategy metadata?
Can you run iis on linux?
what is a composite key ? : Sql dba
Explain fdd?