If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks
7 10816Can 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 10745select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?
5 9139Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
2245How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks
2 6943How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)
6 10468Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation
1 14525In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?
4 9568Post New Puma Interview Questions
What do you understand by business logic?
Explain clustering?
Why do we need npm?
Explain dematerialization?
Why are pointers not used in c++?
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
Explain the difference between keylokup and joiner?
what is the cost and financial accounting? what is double entry system ?
I am getting above 60 V as open delta voltage against single phase unit ICT at tertiary delta formed and ICT getting trippped on NDR. ICT tested and found in order. PTs provided on tertiary are tested and in order. what may be the reason?
What is c preprocessor mean?
Explain grapevine?
How to print all array elements and their respective indexes?
What is excel xml map?
How many sheets can you have in excel 2007?
How create measures and demensions?