4 yrs etl devloper roles and responsibilities?any body give solutions

0 Answers   TCS,

---

Explain the types of lookup transformation?

0 Answers  

---

Major difference between SQL override and Lookup Sql override

1 Answers  

---

is it possible to index the data in cache of lkp transformation ?

0 Answers  

---

How will you display "Mr" for male & "Mrs" for female in target table?

7 Answers  

---

differences between service based and product based?

0 Answers   Satyam,

---

If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?

1 Answers   Amdocs,

---

What is an aggregator transformation? it is active why cant it be passive explain?

3 Answers   HCL,

---

Tell me about MD5 functions in informatica

0 Answers  

---

write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.

5 Answers  

---

What is the internal processes of integration server in Informatica? How data will be extract and load to the target?

0 Answers   TCS,

---

what are the unix commands to start the wrk flow ?

4 Answers   Accenture, TCS,

---