Write a query to display Which deptno is containing highest
Sal > avg (sum (Sal)) of all deptno;
Avg (sum (Sal)) o f all deptno= 9675
Deptno, sum (Sal)
10 8750
20 10875
30 9400
Answer
Is This Answer Correct ? | 1 Yes | 3 No |
Write a query to display Which deptno is containing highest
Sal > avg (sum (Sal)) of all deptno;
Avg (sum (Sal)) o f all deptno= 9675
Deptno, sum (Sal)
10 8750
20 10875
30 9400
Answer
Is This Answer Correct ? | 4 Yes | 1 No |
Question { 6207 }
Is it any possible to using more than one port in Unconnected
Lookup Transformation( :LKP.LKP_Prod(Prod_GRP
,Prod_DT,Prod_TM) ) Like this? Pls explain...
Answer
Is This Answer Correct ? | 4 Yes | 1 No |
Question { 6812 }
When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?
Answer
Is This Answer Correct ? | 4 Yes | 0 No |
Question { 9756 }
Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?
Answer
Is This Answer Correct ? | 0 Yes | 0 No |
Question { 9756 }
Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?
Answer
Is This Answer Correct ? | 0 Yes | 0 No |
while creating the scd mappings. we will mention flag value.
what exactly the use of defining the FLAG VALUE. Please
explaine indetaile
Answer
Is This Answer Correct ? | 4 Yes | 0 No |