what is the advantage of persistent cache? when it should be used?

2 Answers  

---

What is full load & incremental or refresh load?

0 Answers  

---

can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.

1 Answers  

---

if u can't find what you are looking for in lookup table, how do you handle?

1 Answers  

---

What is the difference between Data Warehousing and Data Mining?

0 Answers  

---

how many steps are there in etl process?

0 Answers  

---

When you have 2 servers in two different time zone and if you need to extract data from 1 server and load it in another server, how do you go about it? Best method to be used.

3 Answers  

---

How can we handle Rejection Logic in Source tables while we are matching the data in Target side in ETL Testing ?

2 Answers  

---

What exact we can see in table?

1 Answers  

---

I have a Flat file with more no. of Records also including duplicate values. But i need distinct values to one target and remaining records to another target in Informatica way

2 Answers  

---

how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.

5 Answers  

---

indatastage 8.1 surrgoate key generates seqences numbers write but there is limite value i want to reset the seqence after gettting some highest value like i want o/p like this 1 2 3 4 5 .............10000 1 2 3.........10000

1 Answers   TCS,

---