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

How are indexes created after completing the load process?

0 Answers  

---

Difference between task flow and linear task flow

0 Answers  

---

write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000

1 Answers   HP,

---

HOW DO YOU CONNECT TO REMOTE SERVER ?

1 Answers   Patni, TCS,

---

can you use flat file for lookup table?why?

2 Answers   HCL,

---

i have two tables,table 1 having 2 columns and 3 rows,table2 having 3 columns and 2 rows.what is the output if i do left outerjoin,full outer join,right outer join?

2 Answers   IBM, Polaris,

---

How to elaborate tracing level?

0 Answers  

---

i have oracle table A and target B. i don't know how many records. i want get get last record in table A as first record in target table B. write a sql query?

7 Answers   IBM, TCS,

---

What is session task and command task?

0 Answers  

---

How do you update the records with or without using update strategy?

0 Answers  

---

What is a parameter When and where do you them when does the value will be created

0 Answers  

---

Hi,tell me the system testing and Integration Testing in the Informatica ? Thank You

2 Answers   TCS,

---