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
- 7246 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 |
how to insert header after each group.
Can you start a session inside a batch individually?
what is correlated query?
How does the aggregator transformation handle null values?
How Union Transformation is an Active Trans?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
Which are the different editions of informatica powercenter that are available?
HOW CAN I SEND HALF OF THE RECORDS TO ONE TARGET AND REMAINING TO OTHER TARGET?
what is the drillup & drill down?and use of the drill up and drill down?
how to improve performence by using sorted input in aggrigator t/r.
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?
Teradata 
