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
How can the style/class of an element be changed?
What are the characteristics of the thermodynamic stage of a metal?
Can I set up a connection pool with multiple user IDs? The single ID we are forced to use causes problems when debugging the DBMS.
What is sse?
What does br mean in banking?
What is default value of bool in c#?
When should I use safe mode?
explain requirement class and requiremnt type in detail with business examples
Can informatica load heterogeneous targets from heterogeneous sources?
What are type methods in swift?
Compare convertible & non-convertible shares
What does the language of fopl consist of?
How to write the opening tag of an xhtml element?
Can protocols have properties?
How do I check messages in jms queue?