Answer / mohit sondhi

OLTP is online transaction processing systems and ODS os
operational database system.
In OLTP we can save the current data, it depends on the day
to day transactions and it stores the day to day data.

In ODS we can store data for a month also and it is not
restricted to a specific day or transaction.

Answer / himanshu

OLTP : Online Transaction Processing
The granularity of the data is Transaction i.e. stores each
transaction.

ODS: Operational Data Store
As dataware house contains summarized data
(Weekly/Monthly/Yearly). ODS may be used to maintain data
with lower granilarity (Hourly/Daily).

eg. Data for previous years may be summarized but sould not
be for the current year.

Answer / edh

I've got a web application used for creating product orders
backed by an RDBMS.

The RDBMS contains the necessary tables to store the facts
(orders and orderlines) and reference data (product, vendor,
price, customer, ...).

The RDBMS is ever growing. That is, there's no cleanup of
"old" records (e.g. orders from x years back).

What kind of database is this and why ?
An OLTP, an OLAP, an ODS, ..., something else ?


Please advise.

EDH

Answer / sri47

OLTP refers a transactional Data base.

ODS refers a data base which actually contains the Basic
data like the details of available Procts,and Branches of
Company etc.
Means It will be small in size and can be modified
daily.Most of the times Thos ODs is used for loading the
Dimensions.

hi guys..iam a QA person ..what is ETL TESTING... what is the process of ETL testing... ETLTESTER needs etl devolopment knowledge or not? pls suggest ur valuable decision

2 Answers  

---

In SCD type 2 if we had select date range. then suppose we had inserted today's date(eq. date is 30 aug 2010) then start date will be today's date(30 aug 2010) what will be the end date,we cant leave it blank?

2 Answers   Cognizant, emc2,

---

Where do we use mapping variables in informatica?

0 Answers  

---

Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks

6 Answers   IBM,

---

how to join two flat files in informatica?

3 Answers   Wipro,

---

What are the transformations that are not supported in mapplet?

0 Answers  

---

What is a predefined event?

0 Answers  

---

what is the hint? how to use it to reduce the query processing in program?

3 Answers   Cegedim,

---

What are the types of metadata that stores in repository?

2 Answers  

---

Hi Every One When i Start the Workflow, Table is Going to be Stored in the target database But the columns are not going to the target database table in my PC , please give me the solution and waiting for solution

2 Answers  

---

What is the procedure to load the fact table.Give in detail?

1 Answers  

---

How can i set break points in debugging mode ? can explain steps please?

1 Answers   ABC, TCS,

---