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 10744select * 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 10467Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation
1 14524In 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 Informatica Interview Questions
Define cuttoff frequency?
How do I export xml to excel?
Explain the working of a multiplexer.
List some database related query functions in yii?
Do you know what are the steps required to modify config.xml file of web logic server?
How can you optimize AI models for edge deployment?
What are elliptic curve cryptosystems ?
What all rounds do we have to face in dell(bpo)??
Explain why nitrogen cannot form penta halides?
Why we use dbms for projects? Why don’t we save any application data in separate files instead of dbms?
explain the omportance of "squish" and "swirl" in ci engine
Briefly describe your ideal job?
How is the actual free energy change for a process related to the standard free energy change?
how hydrogen cooled alternator undergo maintanence ? that is hydrogen when come in contact with air can result into explosions .
What is scheduled job and how to create it?