Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is the difference between OLTP and ODS?

Answer Posted / 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.

Is This Answer Correct ?    1 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is an unconnected transformation?

1067


Is there any target staging area in informatica not staging area

2556


What is a pre-defined event and user-defined event?

1025


Please let me know how to make encryption and decryption with example?

1886


What is the Rank index port in Rank transformation?

1046


What is the procedure for creating independent data marts from informatica 7.1?

1047


Separate from a database, an information bazaar, and an information stockroom?

1073


What is joiner transformation in informatica?

1032


Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

2020


What is lookup change?

1032


What is the use of target designer?

1025


What does reusable transformation mean?

1119


How to Create a folder using pmrep command?

1157


What is an aggregator transformation?

1087


Suppose we do not group by on any ports of the aggregator what will be the output?

1031