How to fasten loading of 100 million distinct records in informatica? (Initially they are loaded into target without using any transformation, taking 2 hours)

3 Answers   Atriax,

---

what is the Default Source Option For Update Strategy Transformation?

0 Answers   Informatica,

---

how we load the data from source to staging area

4 Answers   TCS,

---

write a sql query following table some duplicate present 1 1 2 2 3 3 4 5 i want the output unique one column duplicate another column following format like unique duplicate 1 1 2 2 3 3 4 5

2 Answers   TCS,

---

What are the tasks that source qualifier performs?

1 Answers  

---

r u done any partitions in ur project?

0 Answers   TCS,

---

In informatics server which files are created during the session rums?

0 Answers  

---

what is the necessity to use update strategy?(except for updates)

2 Answers   Emphasis,

---

How can you join two tables without any common column present in them?

1 Answers   TCS,

---

what is the difference between onsite & client site?

1 Answers  

---

How can we join the tables if they don't have primary and foreign key relationship and no matching port?

7 Answers  

---

what is rank and dense rank in informatica with any examples and give sql query for this both ranks

4 Answers  

---