If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks
7 8108Can 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 9243select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?
5 7327Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
1734How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks
2 5943How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)
6 8451Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation
1 13299In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?
4 7823Post New Puma Interview Questions
can u share your though about test leakage matrix with template?
What is database url for mysql?
What is routh hurwitz stability criterion?
CSS corp interview process and placement papers
What does webkit mean?
What are the effects of adding a zero to a system?
How do I get rid of system queued windows error reporting?
1. How to test Database? Please, give me all details for "SQL,Msaccess, Mysql Database? 2.For which functionalities database used? 3.How to convert Guest to Admin by Mysql database?
Why olap is used?
Does there exist any way to make the command line arguments available to other functions without passing them as arguments to the function?
What are numerous ways in which a thread can enter the waiting state?
Is clustered index a primary key?
Define gathers?
To generate supply network planning pds data, what should be pds type? : supply chain management
Can we use an equated value as operands for an MVC ? Reason for the same.