Answer / harleen65

Locks applied on target table

What are multi-group transformations?

0 Answers   Informatica,

---

What is meta data and system catalog?

2 Answers  

---

what is diff b/t sorter t/r and agg have the option sorter property...

0 Answers  

---

what is mapping performence?

2 Answers   Cap Gemini,

---

What are the issues that you have faced while moving your project from the Test Environment to the Production Environment?

1 Answers  

---

Transformer is a __________ stage option1:Passive 2.Active 3.Dynamic 4.Static

2 Answers   Accenture,

---

Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions

4 Answers   IBM, Infotech,

---

HOW DO YOU PARFORM INCREMENTAL LAOD ?

7 Answers   SAIC,

---

Why the workflow is failed after running two hours in informatica?

1 Answers   GE,

---

What are teh different tasks that can be created in workflow manager?

1 Answers   NIIT,

---

In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query

8 Answers   Cap Gemini,

---

Hi All, I have three question. 1) How to remove the header and footer in a flat file in informatica? 2)How to load the first and last record of flat file into the target? 3)I have a Input and Output table. Input Name Salaray Month A 100 Jan A 200 Feb A 300 March B 400 April B 500 May B 600 June Output Name Salaray Month A 100 Jan A 300 Feb A 600 March B 400 April B 900 May B 1500 June How to implement and get the ouput as mentioned above. If Possible kindly provide the SQL query also. Kindly any one help to implement this concept. Thanks, Pradeep

3 Answers   CSC, iNautix,

---