Answer / mike

1)Yes..you can use a lookup transformation on flatfiles.

2)I think we can use most of the transformations on
flatfiles.
But we can not apply slowly changing dimensions on flat
files.

correct me if i was wrong

Answer / rajan raorane

No we can apply slowly changin dimensions on flat files
as they are basically used to mantian history

frequently used is SDC2 (Verison/flag/Date)

What do mean by local and global repository?

0 Answers  

---

what is the mechanism of the Master-Detail joining condition?

6 Answers   IBM, Patni,

---

Performance tuning( what you did in performance tuning)

0 Answers   Infosys,

---

Is it necessary to maintain the primary-foreign key relation ship between the targets in informatica while loading using constarint based loading or it is required only at database level ??

1 Answers   IBM,

---

i have two sources both is oracle database . one is coming from USA database and another one is coming from U.k database .i am using source qualifier transformation to join this.as that time in session level source properties which path i need to give to retrieve that data. thanks bala 09619894486

2 Answers   Accenture,

---

what is the difference between Informatica 7.1 and Abinitio?

1 Answers   TCS,

---

how we do performence tuning in informatica

3 Answers  

---

Hi, I have one scenario.. i want to insert 4 times (Duplicate) a row in the target. Please help me . source row: abcabc Tgt table: abcabc abcabc abcabc abcabc

10 Answers   Cap Gemini, IBM,

---

source file name xyz a,0,a,a,a b,b,b,0,b c,c,c,0,c target should be like this xyz a b c how to implement this?

4 Answers   Polaris,

---

can we use cartesian join in informatica

3 Answers   IBM,

---

Is informatica power center designer has 64 bit support?

1 Answers  

---

What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

0 Answers  

---