Scenario is like this: Name Sal A 10; B 20; C 30; Then Output should be Name Sal A 10; B 20; C 30; Total 60; Use SQL For this scenario

4 Answers   TCS, Wipro,

---

What are the associated ports in look up T/R.

5 Answers   IBM, Zensar,

---

Describe expression transformation?

0 Answers  

---

write asql query to filter improper date format? date 20-apr 11-mar-2010 30-may-2010 feb-2009 i want the output date 11-mar-2010 30-may-2010

2 Answers   Accenture,

---

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,

---

---

Q. In source area, it is use complex query we have using 5 to 10 table we has been join now all join clolumn having indexes but still we having performance issue. how to fix the performnce issue of the query.

0 Answers  

---

COM components can be used in Informatica

0 Answers  

---

Write the prerequisite tasks to achieve the session partition?

0 Answers  

---

What are variable ports and list two situations when they can be used?

1 Answers  

---

how to calculate the optimum cache size in aggregator transformation?

1 Answers  

---

How can repository reports be accessed without sql or other transformations?

0 Answers  

---

What is facttable granularity?

2 Answers  

---