dinesh


{ City } chennai
< Country > india
* Profession * software engg
User No # 35200
Total Questions Posted # 71
Total Answers Posted # 4

Total Answers Posted for My Questions # 207
Total Views for My Questions # 483225

Users Marked my Answers as Correct # 21
Users Marked my Answers as Wrong # 38
Questions / { dinesh }
Questions Answers Category Views Company eMail

following table source target name gender name target a1 male a1 female a2 female a2 male i want a1 female update to target how will do?

Patni,

2 Informatica 4986

how many session run unix environment what command using ?

HCL,

1 Informatica 5894

follwing scenario two table using find maximum salary? table a table b 101 xxx 1000 106 6500 103 yyy 5000 108 800 104 din 6000 109 7000 105 dsh 200 110 3000

IBM,

5 Informatica 8181

following scenario empsal table i want who exist one lakshs sal above monthwise? ` empsal empid monthyear sal 1 jan2008 1000 2 march2009 50000 3 april2009 4000 4 feb2009 100000 5 jul2009 600000 6 dec 2008 90000

Wipro,

5 Informatica 7311

without dynamic lookup transformation how to insert new rows and update existing rows?

Cap Gemini,

7 Informatica 14223

one source to target loading insert new rows and update existing rows?

Polaris,

3 Informatica 5977

i have one source 52 million records i want target only 7 records ?how wil you do what logic to implement?

L&T,

7 Informatica 11579

enterprise datawarehouse your project phase by phase explain?

Cap Gemini,

1 Informatica 5520

what is mean by throghput? in informatica

Cap Gemini,

3 Informatica 8533

following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?

BRAD, TCS,

8 Informatica 10278

difference between top down(w.h inmon)and bottom up(ralph kimball)approach?

PayPal,

2 Informatica 14756

what is data driven in update strategy transformation?

HCL, PayPal,

2 Informatica 15839

what is system requirement(SR) & business requirement(BR)?

Ness Technologies,

2 Informatica 5533

how did u understand business requirement?

TCS,

2 Informatica 4758

I have a source either file or db table Eno ename sal dept 101 sri 100 1 102 seeta 200 2 103 lax 300 3 104 ravam 76 1 105 soorp 120 2 Want to run a session 3 times. First time: it should populate dept 1 Second time: dept 2 only Third time: dept 3 only How can we do this?

TCS,

2 Informatica 6330


 [1]   2   3   4   5    Next



Answers / { dinesh }

Question { Mphasis, 13201 }

What are the ETL tools available in DWH?


Answer

1. Oracle Warehouse Builder (OWB)

2. Data Integrator & Services
3. IBM Information Server (Datastage)
4. SAS Data Integration Studio
5. PowerCenter
6. Elixir Repertoire
7. Data Migrator
8. SQL Server Integration Services
9. Talend Open Studio
10. DataFlow Manager
11. Data Integrator
12. Transformation Server
13. Transformation Manager
14. Data Manager/Decision Stream
15. DT/Studio
16. ETL4ALL
17. DB2 Warehouse Edition
18. Pentaho Data Integration
19 Adeptia Integration Server
20 Clover ETL

Is This Answer Correct ?    7 Yes 2 No

Question { IBM, 8181 }

follwing scenario two table using find maximum salary?

table a table b
101 xxx 1000 106 6500
103 yyy 5000 108 800
104 din 6000 109 7000
105 dsh 200 110 3000


Answer

select max(sal) from (select max(sal) as sal from table a)
union
(select max(sal) as sal from table b)

ans:
sal
7000
6000

Is This Answer Correct ?    5 Yes 0 No


Question { ABC, 34087 }

how to get second highest salary from a employee table and
how get a 5th highest salary from a employee table?


Answer

select * from emp e where
2 =(select count(distinct sal) from emp where e.sal<=sal)
or 5=(select count(distinct sal) from emp where e.sal<=sal);

Is This Answer Correct ?    9 Yes 5 No

Question { TCS, 6053 }

Hi experts,
table 1 has 10 records, table 2 has 5 records
select * from table1, table2;
What is the output for this query???....plz answer


Answer

ans:select * from table 1,table2?

45 records(cartisan product)

Is This Answer Correct ?    0 Yes 31 No