What do you mean by enterprise data warehousing?
Answer / Suneel Kumar Sahu
Enterprise Data Warehousing (EDW) refers to a central repository of integrated data from one or more disparate sources, used for reporting and analysis purposes. It is designed to provide consistent, reliable, and timely access to business-critical data across an organization.
| Is This Answer Correct ? | 0 Yes | 0 No |
Hi All, I have three question. 1) How to remove the header and footer in a flat file in informatica? 2)How to load the first and last record of flat file into the target? 3)I have a Input and Output table. Input Name Salaray Month A 100 Jan A 200 Feb A 300 March B 400 April B 500 May B 600 June Output Name Salaray Month A 100 Jan A 300 Feb A 600 March B 400 April B 900 May B 1500 June How to implement and get the ouput as mentioned above. If Possible kindly provide the SQL query also. Kindly any one help to implement this concept. Thanks, Pradeep
In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and the other is from Sybase.
what is constraint based load order
How many types of sessions are there in informatica.please explain them?
whats the option in informatica 7 version is outdated in informatica 8 version onwards.
What is the Hierarchy of DWH?
where does the default group roew in a router is stored what is the default size of memory in router
how many types of dimensions are available in informatica?
if i have source with 100 records target with 100 records and we lookup on another database table and it has 10 million record so what is the method of limiting that much record in lookup table?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
whats the logic to load the lower level of granularity of data to fact table.
how to work with mapplet designer in informatica?