what is the architecture of any Data warehousing project?
Answer Posted / kumarapillaietl@gmail.com
first we integrate data into source to staging tables, from staging we movie into work table at the data moment of stage to work we do all transformation logic , then from work table we load data into fact and dimention table using scd 2.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is dimensional table?
what is mean by complex business rule ?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What are the data movement modes in informatica?
what are 3 tech challenges/ common issues you face?
What is the Rank index port in Rank transformation?
Explain about Informatica server process that how it works relates to mapping variables?
What are the mapping parameters and mapping variables?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Write the unconnected lookup syntax and how to return more than one column.
What is the fact table?
Tell me about MD5 functions in informatica