If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks
7 10603Can 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 10608select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?
5 8966Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
2184How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks
2 6851How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)
6 10294Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation
1 14430In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?
4 9397Post New Puma Informatica Interview Questions
What do you mean by index hunting?
How do I close a browser window with html code?
What is the main difference between java platform and other platforms?
What are the rules to implement connection pooling?
What is de-partition in abinitio?
What is independent and dependent variables in research?
Describe a time when you anticipated potential problems and developed Preventive measures
Define what options are there to implement a multi language site ?
How many tickets you have solved till date? can you please elaborate it with solutions?
what is soa record? : Windows server 2003
What is the need for indexing?
What is pytables?
Why is main an int?
How do I install windows 7 on a windows 10 laptop?
how to use telugu language in vb6? any unicode data is available for telugu or not?yes means how to use? my desired output is telugu only? i am doing project like(telugu calendar),my output should be print in telugu only? pls send me the solution with code?