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
- 7009 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / seshagiri k
By using Target load order plan and based on primary foreign
keys to load the data into n no of dimensions
If it wrong pls send the correct answer to my mail
| Is This Answer Correct ? | 1 Yes | 4 No |
what is worklet and what use of worklet and in which situation we can use it?
If informatica has its scheduler why using third party scheduler?
What is the procedure for creating independent data marts from informatica 7.1?
What is the difference between a connected look up and unconnected lookup?
when will we use unconnected & connected lookup? How it will effect on the performance of mapping?
What is power play plug in?
If I have router with 10 records, if the condition doesn’t satisfy the records will pass to the default group,then where can we see that records and where that records will store?
is it reqire primary key and foreign key relation ship to join relational databases?if yes? explain?
What are the different caches used in informatica?
enterprise datawarehouse your project phase by phase explain?
S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?
What is Test load plan? Let us assume 10 records in source, how many rows will be loaded into target?
Teradata 
