Data warehouses are
designed to perform well with aggregate queries running on large amounts of
data.
The structure of data warehouses is easier for end users to navigate, understand and query against unlike the relational databases primarily designed to handle lots of transactions.
Data warehouses enable queries that cut across different segments of a company's operation. E.g. production data could be compared against inventory data even if they were originally stored in different databases with different structures.
Queries that would be complex in much normalized databases could be easier to build and maintain in data warehouses, decreasing the workload on transaction systems.
Data warehousing is an efficient way to manage and report on data that is from a variety of sources, non uniform and scattered throughout a company.
Data warehousing is an efficient way to manage demand for lots of information from lots of users.
Data warehousing provides the capability to analyze large amounts of historical data for nuggets of wisdom that can provide an organization with competitive advantage.
About parameter files:
The structure of data warehouses is easier for end users to navigate, understand and query against unlike the relational databases primarily designed to handle lots of transactions.
Data warehouses enable queries that cut across different segments of a company's operation. E.g. production data could be compared against inventory data even if they were originally stored in different databases with different structures.
Queries that would be complex in much normalized databases could be easier to build and maintain in data warehouses, decreasing the workload on transaction systems.
Data warehousing is an efficient way to manage and report on data that is from a variety of sources, non uniform and scattered throughout a company.
Data warehousing is an efficient way to manage demand for lots of information from lots of users.
Data warehousing provides the capability to analyze large amounts of historical data for nuggets of wisdom that can provide an organization with competitive advantage.
About parameter files:
Parameter file is
any text file where u can define a value for the parameter defined in the
informatica session, this parameter file can be referenced in the session
properties,When the informatica sessions runs the values for the parameter is
fetched from the specified file. For eg : $$ABC is defined in the infomatica
mapping and the value for this variable is defined in the file called abc.txt
as
[foldername_session_name]
ABC='hello world"
In the session properties u can give in the parameter file name field abc.txt
[foldername_session_name]
ABC='hello world"
In the session properties u can give in the parameter file name field abc.txt
You can pass a
parameter value to a task using a file, Mostly it will be used in dynamic value
assignment
If you like this post, please share it by clicking on g+1 Button.
No comments:
Post a Comment