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 |
What is a diff between joiner and lookup transformation
16 Answers CTS, Satyam, TCS, UHG,
Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..
tell me 5 session failure in real time how can you solve that in your project?
wf dont have integration severances how you can run?
Any one tell me some 5 session failure in real time?And why problem occur how to solve the issues?
Explain the difference between a data warehouse and a data mart?
How to elaborate tracing level?
Can anyone give some input on "Additional Concurrent Pipelines for Lookup Cache Creation" ? I know that this property is used to build caches in a mapping concurently. But which values should I set into this ( i.e. 1 or 2 or 3 or something else ) for concurrent cache building ?
what is the significance of newlookup port in dynamic look up
if i have a file having record sal=10000,and when use router with two groups having condition sal>5000 in one group,sal>7000 in other group.and if two groups connected to two targets.in which target sal=10000 will go?
9 Answers BirlaSoft, Genpact, L&T, Syntel,
what is meant by data driven.. in which scenario we use that..?
How do you change a non-reusable transformation to reusable transformation?