how many data models u have done in informatica project?

2 Answers   TCS,

---

write a sql query following source? subject mark maths 30 science 20 social 80 requird output maths science social 30 20 80

3 Answers   iGate,

---

How to convert flat file into xml file? How to tune joiner?

2 Answers   Accenture,

---

Have you worked with/created Parameter file

0 Answers  

---

What is a surrogate key?

0 Answers  

---

How to generate or load values in to the target table based on a column value using informatica etl tool.

0 Answers   Informatica,

---

with out using update strategy transnsformation how to update the data in mapping level

1 Answers  

---

What are the different types of Type2 dimension maping?

1 Answers  

---

I am having source ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI Target ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI If a new record coming from source from same location it should directly go to specified location in target at begining EX:if Eno with 4 coming from same Pune, It should directly load into the Pune location col with '|' symbol. Help me its very urgent

5 Answers   Polaris, Zensar,

---

how many types transformations supported by sortedinput?

4 Answers  

---

sorce is a flatfile only 1st and last row should insert to target how will u do?

2 Answers   HCL,

---

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

1 Answers   HP,

---