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
- 7154 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 |
Want to know about Training Centres for Informatica, Cognos and ETL Softwares in Mumbai, India.
whats the option in informatica 7 version is outdated in informatica 8 version onwards.
Can a joiner be used in a mapplet.
Hi, Can someone send me the DWH and Informatica FAQ's at priti.singh84@gmail.com Thanks in Advance, preeti
Hi All, I've 110 records in my table but 101 records contains an error. When I run the session, I want to load the 100 records into the target. Can anyone suggest me the best solution for this... Thanks in Advance,
When to use normalization transformation other than cobol source?
wat transf shud i use to achieve this id sal id sal sum src-1 20 tgt 1 20 40 1 20 1 20 40 2 15 2 15 35 2 20 2 20 35
Where are the source flat files kept before running the session?
How to generate sequence numbers using expression transformation?
Explain sessions?
Can we create a Integration service without a Repository service and vice versa?
Source (Flatfile) - Target (1-1 mapping). How to load first or last 20 record to target?
Teradata 
