Interested to Buy Any Domain ? << Click Here >> for more details...
without using ETL tool can u prepare a Data warehousing and
maintaining?
- 3 Answers
- 7992 Views
- I also Faced
- E-Mail Answers
Answer Posted / zak
Theoritically speaking Yes. Preparing a Datawarehouse and
maintaining will only be feasible when the amount of Data
you are dealing with is small. Practically Datawarehouses
will have huge data with large number of tables and complex
business rules which may keep changing from time to time.
All this makes practically impossible to implement DWH just
by writing database queries.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
how would u estimate the size of Aggregator transform data and index cache?
how do u identify the changed records in operational data?
Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks
Identifying the bottlenecks in various components of Informatica and resolving them.
Explain do we need an etl tool?
explain the methodology of Data Warehousing?(Polaries)
what are the session parameters? How do u set them?
What are the modules in Power Mart?
Which transformation we use to convert 'NA' to 'Not Available'
1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
What is data cleaning?
How many types of transformations supported by sorted input?
What are the etl testing operations includes?
Explain about hash partitioning?
