If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks
7 10601Can 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 10292Why 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 Interview Questions
How do I fix outlook not receiving emails?
what is the scope of php in the future if any other language is developed then may be php is loss ???
I have a dataset concat having a variable a b & c. How to rename a b to e & f?
How much confident you are in working individually in terms of
How do you approach discussions about treatment risks, benefits, and potential side effects with patients and their families?
How is control over public deposits exercised?
How to integrate the ssrs reports in application?
How you will do SubString in XSL
If you are stuck in a situation, how will you handle it.
What is the structure of entire gsm?
What is artificial intelligence journal?
Tell me about view, sequence and index in DBMS.
What are global variables in php?
What is the use of configuring number ranges in sap srm system?
Sir, My doubt on cable sizing calculation, Load:74 KW calculated cable 1 run 50mm2. Now client asking us to reduce cable size by increasing runs. Sir, My question now when my mind strikes with 2 options 1) Divide load 74/2 = 36 and calculate cable for 36+36 making it 2 runs or 2) Simply i can divide 50mm2 /2 ie. 2 runs of 25mm2 Please suggest me sir