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,

---

Had any one faced informatica(ETL/Developer), Datawarehouseing interview in UK. Than plz help me (i have any exprience of 3yrs informatica,datawarehousing,oracle,teradata) 1.hw the procedure will b here 2. wht type of question's they will b asking. 3.In which area they concertate more. since this is the first time im facing interview in UK. plz help ASAP.it will b a great help for me thanks to All in Advance

2 Answers  

---

What is the functionality of update strategy?

2 Answers  

---

what is constraint based load order

2 Answers   Cap Gemini,

---

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

2 Answers  

---

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

0 Answers  

---

Explain target update override in informatica

0 Answers   Informatica,

---

What is a dimensional model?

0 Answers  

---

what are objects in data warehouse?

2 Answers   Mind Tree,

---

i did MBA in 2008. i got job as a Software Engineer(Informatica) in 2008 February in our college campus interviews through consultancy. my problem is when iam going interview HR people ask " YOu are MBA graduate how u get software(informatica) job". iam saying i got job in campus interviews. i have knowledge in informatica in dataware housing. is this answer correct or not. plese give me guidence

1 Answers   IBM,

---

Is stop and abort are same in informatica?

0 Answers  

---

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

0 Answers  

---