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?
2 Informatica 4986follwing 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 8181following 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
5 Informatica 7311without dynamic lookup transformation how to insert new rows and update existing rows?
7 Informatica 14223i have one source 52 million records i want target only 7 records ?how wil you do what logic to implement?
L&T,
7 Informatica 11579following 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?
8 Informatica 10278I 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
What are the ETL tools available in DWH?
Answer
Is This Answer Correct ? | 7 Yes | 2 No |
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
Is This Answer Correct ? | 5 Yes | 0 No |
how to get second highest salary from a employee table and
how get a 5th highest salary from a employee table?
Answer
Is This Answer Correct ? | 9 Yes | 5 No |