Answer Posted / sivaprasad

Gradually to synchronize the target data with source data,
there are further 2 techniques:-
Refresh load - Where the existing data is truncated and
reloaded completely.
Incremental - Where delta or difference between target and
source data is dumped at regular intervals. Timsetamp for
previous delta load has to be maintained.

What is joiner change?

1146

---

What is the use of transformation?

996

---

How do you manage the Parameter files while migrating your data from one environment to another environment?

1017

---

What is a snowflake schema?

994

---

Write the advantages of partitioning a session?

1282

---

COM components can be used in Informatica

2390

---

Explain the different lookup methods used in informatica?

1042

---

4 yrs etl devloper roles and responsibilities?any body give solutions

2168

---

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

7449

---

Explain incremental aggregation in informatica

1128

---

How you know when to use a static cache and dynamic cache in lookup transformation?

1854

---

What is session task and command task?

1294

---

Explain the difference between a data warehouse and a data mart?

1056

---

What are the different types of olap? Give an example?

1054

---

What are the limitations of joiner transformation?

1112

---