If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks
7 8181Can 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 ?
1748How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks
2 5971How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)
6 8512Why 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 7864Post New Puma Informatica Interview Questions
If while installing a package with pip, you get the error no matching installation found, what can you do?
Explain how is data loaded from database?
How many data types are there in python?
How long do struts last?
why should small green grass ans small plant should not be there inside the transformer Yard in the factories
Now a days , Mobile devices are coming in different sizes so how to test app on various sizes ? I know from emulator but is there any specific resolution needs to target?
What are the tables used for access control?
Did magento buy adobe?
What is revaluation of Accounts, how does it is accounted in business
What is subsequence of a string?
What are permission sets and how do they differ from profiles?
What is solid in oops?
Give the order of sql select?
What is full form of aspx?
What is database bounce?