If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks
7 10638Can 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 10630select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?
5 8992Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
2192How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks
2 6868How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)
6 10323Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation
1 14441In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?
4 9419Post New Puma Informatica Interview Questions
What is servlet? Explain
Which windows version is fastest?
how many types of survey and what are levelling instrument?
Whats the advantages using servlets over using CGI?
How does thread synchronization occurs inside a monitor? What levels of synchronization can you apply?
How can we make a class singleton?
List the different index configurations possible for a table?
What is the steam consumption formula?
What is moment of inertia?
What are the steps use to improve the performance of magento?
What is the use of the vacancy assignment infotype (4002)?
Tell me why do we convert frequency domain to laplace domain?
What factors go into designing the vapor space of kettle type reboiler?
What is the purpose of a file extension?
Explain the function done by data manager?