Answer Posted / rajesh

im explained earliarly as follows,

im working under insurence domain project, usually i
extract the data from defferent sources like flat files,
oracle, db2.

first we load the extracted data into intermidiate staging
area, where we are having 150 tables, and again we extract
data from intermediate staging area and we load into an
other staging area where we are having event and value base
tables

we transfom the data into staging according to the business
requirement , to transform the data i used trasformations
like expression, lookup,update strategy,joiner wtc

Explain in detail scd type 2 through mapping.

1039

---

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

2049

---

Define filter transformation?

1090

---

Which are the different editions of informatica powercenter that are available?

1030

---

Can you generate sequence numbers without using the sequence generator transformation?

1117

---

Explain the shared cache and re-cache?

1111

---

While importing the relational source definition from the database, what are the metadata of source that will be imported?

1261

---

How do you set a varible in incremental aggregation

1882

---

What is xml source qualifier transformation in informatica?

1217

---

IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

1038

---

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

2554

---

What does cheating measurement mean?

1046

---

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

1103

---

How do you take back up of repository?

1158

---

Enlist the advantages of informatica.

1062

---