If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks
7 8096Can 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 9231select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?
5 7315Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
1731How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks
2 5935How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)
6 8447Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation
1 13290In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?
4 7806Post New Puma Informatica Interview Questions
what will you do if a disk gets failed?
Explain what is standard unix streams ?
What is one to many relationship hibernate?
What are custom labels in salesforce? How to access custom labels? What is the character limit for custom labels?
In how many ways you can overload a method?
What is making the news today?
Explain stress corrosion cracking?
Explain controller in codeigniter?
Is python scripting easy to learn?
Explain what is the difference between a string copy (strcpy) and a memory copy (memcpy)? When should each be used?
What do know about tee command and its usage?
Will retail sector sustain upto 2025
Is typescript an oop?
Differentiate between support packages and kernel upgrade.
What do you know about plastic currency?