rakesh


{ City } hyderabad
< Country > india
* Profession * etl developer
User No # 62145
Total Questions Posted # 12
Total Answers Posted # 22

Total Answers Posted for My Questions # 34
Total Views for My Questions # 97296

Users Marked my Answers as Correct # 94
Users Marked my Answers as Wrong # 25
Answers / { rakesh }

Question { iGate, 8962 }

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

select deptno, sum(sal) from emp group by deptno having sum(sal)>(select avg(sum(sal)) from emp

Is This Answer Correct ?    1 Yes 3 No

Question { iGate, 8962 }

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

select deptno, sum(sal) from emp group by deptno having sum(sal)>(select avg(sum(sal)) from emp group by deptno);

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

I think the question is can we pass multiple inputs to an
unconnected lookup. If I am correct, the answer is YES.

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

We can use unconnected lookup multiple times in the same
mapping if required.

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

What if A and B eixist in different Databases..?

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

if source n targer exist in
different databases you can
create Database link in any of
the database for other one..

create database link "dblink
name"
connect to schemaname
identified by password
using 'Database name';

Is This Answer Correct ?    0 Yes 0 No

Question { Amdocs, 5784 }

while creating the scd mappings. we will mention flag value.
what exactly the use of defining the FLAG VALUE. Please
explaine indetaile


Answer

in SCD2, the flag value indicates whether the record is the active record(Current version of the record) or not.

Is This Answer Correct ?    4 Yes 0 No

Prev    1    [2]