Answer Posted / vaibhav bhandeo

CDC stands for change data capture. This is used to
implement incremental load approach in data warehouse.
In this approach we traditionally keep a date field and
pull data on incremental date values.
This assures that we are picking latest data (Or may be new
batch data which ever is applicable).
Implementing this in mapping would require you to use
parameter files which will keep HiWaterMark and LoWatermark
which is repeatedly used to capture fresh data.

What is fact table? Explain the different kinds of facts.

1126

---

What is decode in informatica?

1256

---

server hot-ws270 is connect to Repository B. What does it mean?

2654

---

Briefly define reusable transformation?

1184

---

Can we create two repositories on same database instance in oracle?

1145

---

what are the Methods For Creating Reusable Transformations?

1257

---

What is a stored procedure transformation?

1113

---

How to join three sources using joiner? Explain though mapping flow.

1191

---

What do you understand by a term domain?

1173

---

Plz can any one say me how to get the informatica certification materials and dumps

2101

---

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1680

---

What are the issues you have faced in your project? How did you overcome those issues?

2413

---

What is data transformation manager process?

1222

---

i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

2170

---

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1128

---