Interested to Buy Any Domain ? << Click Here >> for more details...
what is the logic will you implement to laod the data in to
one factv from 'n' number of dimension?
- 3 Answers
- 7092 Views
- I also Faced
- E-Mail Answers
Answer Posted / sridhar
if u using star schema to u have to develop the dim tables depends on requirement(like scd1,2,3) then u have to look up on all dim tables using natural keys,when the session time u have to load dim's are sequence process like (s1-s2-s3-s4--eventraise)then all success u can load fact load by using eventwait in concurent manner.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is resilience time?
In informatics server which files are created during the session rums?
Explain the tuning lookup transformation - informatica
How can we store previous session logs?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What are the types of schemas we have in data warehouse.
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What is a snowflake schema?
Can informatica load heterogeneous targets from heterogeneous sources?
What is the reusable transformation?
What is event and what are the tasks related to it?
What are some examples of informatica etl programs?
Define update strategy?
How to do unit testing in informatica?
