what is the logic will you implement to laod the data in to
one factv from 'n' number of dimension?
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 |
TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER TRANSFORMATION ?
(Integ) Start workflow: ERROR: User [practice] does not have sufficient privilege for this operation. how to solve this pls suggest me? THANKS in advance
I have the source like col1 col2 a l b p a m a n b q x y How to get the target data like below col1 col2 a l,m,n b p,q x y
following table source target name gender name target a1 male a1 female a2 female a2 male i want a1 female update to target how will do?
What is workflow? What are the components of workflow manager?
how many new transformations are introduced in 8.1 which are not available in 7.1? any new transformation in 8.6?
As a support project team member, how will you get the questions regarding errors from client or customers (in which format)?
To achieve the session partition what r the necessary tasks u have to do?
wht target override?wht advantages it has compare to target update?
what is the difference between copy object import objects using repositery manager which one is best
What is mapping debugger?
What are Dimensions and various types of Dimensions?