Answer / swetha

Normal (Default)

Master outer

Detail outer

Full outer

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 new features of informatica 9.x in developer level?

0 Answers  

---

Hi, As shown below i have repositories under that some folder are there . Between these repositories and folder some thing is there.I want to know what is that? repositories repo1 repo2 repo3 IS_## IS_## IS_## Folder1 Folder2 Folder3 - - - Here i want to what IS_## represents ? Advance Thanks

1 Answers   IBM,

---

i want excute multiple sessions in one workflow using the "start task".what do i need to do?

2 Answers  

---

List the transformation in informatica.

1 Answers   TCS,

---

Can any one describe what is audit table briefly?how does it look like and what are the columns in it?

3 Answers   Syntel,

---

how we can update a target table without update strategy and update override?

3 Answers   TCS,

---

When will u go for Dynamic Cache and Persistent Cache? Pls explain with an example?

2 Answers   TCS,

---

can u apply SCD2 on flat file tgt? if yes wat is the procedure?

3 Answers   Deloitte,

---

which quality process u can approach in ur project

1 Answers   CTS,

---

Hi i am new to Informatica. I have few question's in Informatica. Can any one respond, it will be appricaited. Q.Is Flat File Contains the Dynamic Cache?

6 Answers  

---

WHAT IS USE OF SQL OVERRIDE IN SOURCE QUALIFIER? chandumba2005@gmai.com

2 Answers   TCS,

---