If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks
7 8174Can 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 9283select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?
5 7368Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
1745How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks
2 5970How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)
6 8508Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation
1 13319In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?
4 7859Post New Puma Interview Questions
What is the unit of charge and current?
The inventer is a battery, but if lost current at home u will turn on the fan but the is AC and inventer battery is dc . Then how the fan was rotating. What device Or machine in fan converst the Dc power to Ac power
How to calibration coriolis flow meter?
What is method chaining in jquery and what are the advantages?
How do you conduct a scenario analysis?
How can we create objects if we make the constructor private ?
What needs to be done while starting the database?
What are hooks in code?
What is a semantic tag?
Is html tag mandatory?
Distinction between Private Co. & Public Co.
How can we store rows in PL/SQL using array?
What is java console application?
Give me different ways to invoke an apex call out from queueable class?
Is singleton class immutable?