If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks
7 8645Can 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 9544select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?
5 7681Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
1828How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks
2 6159How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)
6 8888Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation
1 13619In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?
4 8250Post New Puma Interview Questions
What is query syntax?
Explain the term shell.
What is blind sql injection?
Why is spring used?
For the same order of doping, why does n-type semiconductor exhibit larger conductivity than p-type semiconductor?
How to set data for a spinner control?
What is final in scala?
npa is either person or account
What is the shortcut to zoom back to 100%?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
What are the various systems of accounting? Explain them.
How do you implement Ajax using hide() function in JQuery?
What is a lead in sap crm?
What does ctrl z do linux?
how flow current in 220 kv line to line