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
- 6977 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 connected or unconnected transforamations?
How do you set a varible in incremental aggregation
How can you change from reusable session into non-reusable session.
How do you change a non-reusable transformation to reusable transformation?
in a table it has 200 rows the query is select 150 from tablename.whats the output
what is plsql table?
If there are more than one sessions running parallel in a worklet, which will be the last session ?
How can you recover the session in sequential batches?
What are junk dimensions?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
i have 50500 records in my source.if wf run for the first time it will load 1000 records into 1 tgt,if runs second time it will load to another tgt.targets are FF and it is need to be created dynamically.how many tgt will be created and how?
What is a joiner transformation?
Teradata 
