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

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

0 Answers   Informatica,

---

what is DSS?

3 Answers  

---

Explain about Recovering sessions?

1 Answers  

---

What is the advantage of informatica?

0 Answers  

---

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

1 Answers   TCS,

---

can v update d records in target using update stargey without generationg primary key ? explain

4 Answers   CTS,

---

why we are using surogate key in real time give me explanation

2 Answers   TCS,

---

 Code page compatibly –Where all changes are made to handle the scenario.

1 Answers   DELL,

---

where to store informatica rejected data?

0 Answers  

---

WE HAVE 10 RECORDS IN SOURCE IN THAT GOOD RECORDS GO TO RELATIONAL TARGET AND BAD RECORDS GO TO TARGET FLAT FILE ? HERE IF ANY BAD RECORDS MEANS ITS LOAD INTO FLAT FILE AND SEND AN EMAIL , IF NO BAD RECORDS MEANS NO NEED TO SEND EMAIL . PLZ HELP ME ...

1 Answers  

---

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

0 Answers   TCS,

---

What is a snowflake schema?

0 Answers  

---