Can anyone know that what is the Source File limitation in Informatica? To be more precise .. how many flat file we can use as a source in a mapping if.. 1) The Structure of flat files are same & 2) If the Structure of flat files are different. Please explain the procedure also if it dosn't bother one much!!

2 Answers  

---

How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)

6 Answers   Puma,

---

how to identify new and old values in source qualifier or any other transformations using informatica

2 Answers  

---

what is the difference between Informatica 7.1 and Abinitio?

1 Answers   TCS,

---

Design a mapping to load the cumulative sum of salaries of employees into target table?

0 Answers   Informatica,

---

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

0 Answers  

---

What is the difference between warehouse key and surrogate key?

1 Answers   Accenture,

---

is it reqire primary key and foreign key relation ship to join relational databases?if yes? explain?

3 Answers   IBM,

---

What are the issues that you have faced while moving your project from the Test Environment to the Production Environment?

1 Answers  

---

how will you remove the duplicate records from flat file without using sorter?

7 Answers  

---

can u give example for factless fact table

2 Answers   TCS,

---

WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?

7 Answers   Target,

---