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 checksum termnology in informatica? Where do you use it ?

3 Answers   Chase, Cognizant, Deloitte,

---

Can we update a target table (without primarykey) by using update strategy transformation?

4 Answers   TCS,

---

How to add source flat file header into target file?

3 Answers   Logica CMG,

---

Which means the first record should come as last record and last record should come as first record and load into the target file?

0 Answers   Informatica,

---

Why we require dwh in particular projects?

1 Answers   Amdocs,

---

How do you Merge multiple Flat files for example 100 flat files with out using Union T/F

4 Answers   IBM,

---

1,If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?

4 Answers   CompuSoft, EDS, TCS,

---

how to we create datamart?

2 Answers   HSBC,

---

How can yoU improve session performance in aggregator transformation?

8 Answers   TCS,

---

What is the difference between procedure and stored procedur?

2 Answers   IBM,

---

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

0 Answers   CTS, FEEE, TCS,

---

Where do we use mapping variables in informatica?

0 Answers  

---