If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks
7 8171Can 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 9281select * 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 5968How 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 13318In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?
4 7850Post New Puma Informatica Interview Questions
What is the use of figcaption tag in html 5?
How do I get 64 bit java?
Explain the number or character entered through keyboard gets converted to equivalent ascii code & it get stored on ram in the binary form. What is the exact procedure on hardware that converts the ascii value to binary? : .NET Architecture
How do you merge text boxes in word?
What is ng bind html?
What is apache access?
How to start and stop spark in interactive shell?
Write the differences between dynamicresource and staticresource?
What is the default time of cookie in php?
What is c language and why we use it?
What is a simple graph?
If Web site developer want to evaluate their current authoring tool, where would they start?
What is the difference between basic type and idoc type?
To put a "close window" link on a page ?
What action do you have to perform before retrieving data from the next result set of a stored procedure ?