what is the logic will you implement to laod the data in to
one factv from 'n' number of dimension?
- 3 Answers
- 7332 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 are the different types of transformation available in informatica. And what are the mostly used ones among them?
Can we create multiple integration service on single repository?
HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND LOOKUP?
if we have a delimiters at unwanted places in a flat file how can we over come those.
How to load query faster,so that It will take less time to load?
Define Pmrep command?
what is degenerated dimension?
there is a comma separated flat file as source and there is a column in that one field is having space like "rama krishna" like that what happens when this is used as source
Can anyone please distinguish what is Inner join and Outer join
How to recover the standalone session?
how can send duplicate records to one tableand non duplicate records to one table with simple clear mapping?
I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in 3rd target? I am new to Informatica,can anybody suggest me the idea?
Teradata 
