Answer / vaishali bisht

whenever we load data in flat file it automatically override the old data.

Answer / james

whatever data u want to delete from target table,simply go
with truncate option.

what is upstream and downstream transformation?

7 Answers  

---

how do u use sequence created in oracle in informatica? Explain with an simple example

6 Answers   CTS,

---

What are the reusable transforamtions?

2 Answers  

---

what is the look up transformation?

2 Answers   Informatica,

---

Hi, What is version control in Informatia ? Can anyone just give an idea or introduction about this? Advance Thanks

2 Answers   IBM,

---

---

how to get the only updated records in the target

2 Answers  

---

I am having a FLAT FILE SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 to a FLAT FILE only.For more clarification i want to elimate nulls and want in a single line. Please help me out

5 Answers   IBM,

---

Data transformed successfully from Source table to target table. Now how you will ensure that the data in Target table is proper. I answered will verify one or two records and check Then question was that the Development is doing (1-2 record verification)but as a tester you have to verify the complete data, how you will do?? Please answer

2 Answers  

---

What is meant by lookup transformation?

0 Answers  

---

In CSV flat file date are in the following format. dd/mm/yyyy (05/01/2005)and d/m/yyyy (5/1/2005) and dd/m/yyyy (05/1/2005) and d/mm/yyyy (5/01/2005). It should be load to target in a unique format. How will you implement this?

1 Answers  

---

In my sourse i have like ename,gender vasu,male geetha,female ram,male suma.female kesav,male in my output i need male,female vasu,geetha ram,suma kesav

5 Answers  

---

How do you load only null records into target?

0 Answers  

---