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.

Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.

10 Answers   CSC,

---

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  

---

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,

---

Hi, Can someone send me the DWH and Informatica FAQ's at priti.singh84@gmail.com Thanks in Advance, preeti

1 Answers   Accenture, Patni,

---

Can we use unconnected lookup as dynamic lookup?

5 Answers   ITC Infotech, TCS, Wipro,

---

what is the difference between look up and joiner(don't say joiner sopport only = where as look up support non-equijoin).

3 Answers   IBM, ITC Infotech,

---

What happens if the info. Server doesn't find the session parameter in the parameter file?

1 Answers  

---

If i havee 3records in my source having same deptno like Deptid Deptno ------ ------ 101 10 201 10 301 10 and i am using router TR to loading these records into target.Then how many record'll be loaded into target???

5 Answers   Wipro,

---

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

0 Answers  

---

how can we check whether a particular cache is static or dynamic?

1 Answers   InfoCepts, TCS,

---

What are slowly changing dimensions?

5 Answers   Informatica, Verinon Technology Solutions,

---

What is a unit Testing?

1 Answers  

---