what is the architecture of any Data warehousing project?
Answer Posted / bsgsr
i simply put this way.
source to staging
staging to dwh
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What are the performance considerations when working with aggregator transformation?
What are the static cache and dynamic cache in informatica?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What is data caches/ index caches?
write a query to retrieve the latest records from the table sorted by version(scd)
What is persistent lookup cache?
What are the types of schemas we have in data warehouse and what are the difference between them?
Sequence generator, when you move from develoment to production how will you reset
What is a sequence generator transformation?
How many number of sessions can one group in batches?
What are the different clients of powercenter?
What is a joiner transformation?
Differentiate between reusable transformation and mapplet.
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
How to configure mapping in informatica?