Answer / rajan raorane

Informatica describes about Extraction , Transfotrmation
and Loading
Extraction from OLTP database
Transfromation done on the exctracted Data
Load in DWH

OLTP-->ETL(informatica)-->DWH-->OLAP

Informatica 8.6 is inclusive of Repositary and Integrated
services
Repositary: Are used to create user and assign previliges
Integration Services: these are used to
1)create folders in Repositary Manger
2)design Mapping in Power Designer
4) Create Session and Work flow in Workflow designer
5) Status you can observe in Work flow monitor

Answer / vemuri vijay

just tell about
client
and
services

What is a router transformation?

0 Answers  

---

wt is informatica file watch timers in aflat i want to get the first record and last record how could i.

1 Answers   CTS,

---

when we go for unconnected lookup transformation? and why?

5 Answers   Accenture,

---

i have two sources both is oracle database . one is coming from USA database and another one is coming from U.k database .i am using source qualifier transformation to join this.as that time in session level source properties which path i need to give to retrieve that data. thanks bala 09619894486

2 Answers   Accenture,

---

How do you change parameter when you move it from development to production.

1 Answers  

---

Explain scd type 3 through mapping.

0 Answers  

---

Is it possible to create multiple domains on a single Informatica server?

0 Answers  

---

What are the data movement modes in informatica?

0 Answers   Informatica,

---

Can we use unconnected lookup as dynamic lookup?

5 Answers   ITC Infotech, TCS, Wipro,

---

with out using update strategy transnsformation how to update the data in mapping level

1 Answers  

---

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

1 Answers   TCS,

---

What is the use of an aggregator cache file?

0 Answers  

---