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,

---

What are the restrictions of union transformation?

0 Answers  

---

Any one tell me some 5 session failure in real time?And why problem occur how to solve the issues?

1 Answers   Amdocs,

---

Limitation of REPLACESTR. Is there any character limitation to it.

1 Answers   CTS,

---

Hi , Please help how to achieve the following scenario. I have a source table like this. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU I need the data in the target table like below. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU 4 Rajesh 5th SKU The Last row values we have.. and we have to append this last row in the target table. Thanks and Regards Nataraj V

3 Answers   NTT Data,

---

Hi I have two sources like A, B. My source A contain 10000 million records from that i need 20 attributes. My source B has also same 10000 million records from that i need only 1 attribute. By using Joiner i have to load into target? Is there any issue regarding this? if issue is there how to tune this mapping in best way?

2 Answers   Zensar,

---

What is meant by target load plan?

0 Answers  

---

i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.

10 Answers   Emirates, IBM,

---

In session log thier should not be a single error how will u do

3 Answers   HCL,

---

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

0 Answers  

---

What are the mapings that we use for slowly changing dimension table?

2 Answers  

---

What is ThroughPut in Informatica, How it works, Where I can find this option to check ?

5 Answers   CTS,

---