Interested to Buy Any Domain ? << Click Here >> for more details...
how can u load the data in time dimension?
- 3 Answers
- 12449 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ankit kansal
Hi,
I have created one example closely have a look. I hope it ll help you.
follow the link
http://deepinopensource.blogspot.in/2013/07/date-dimension-using-informatica.html
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / subh
Normally one time loading process is followed for time
dimension. this might be achived by running one time insert
script.
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / krishna
in general data is loaded into the time dimension using an
excel file which holds the data starting from a certain
period of time and this is divided into months,days date,
year and all such attributes.
| Is This Answer Correct ? | 2 Yes | 4 No |
Explain constraint based loading in informatica
How can we use mapping variables in informatica?
How to do unit testing in informatica?
how to send unique records to one target and duplicate records to another target by using dynamic lookup cache????? please explain me briefly///(when we use this we look up on which target unique target ya duplicate target)
how can we update without using update transformation. wt is push down operation in informatica. which lookup gives more tuning performance. if so why.
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
How to jion 2 tables, without using any condition?
What is the Hierarchy of DWH?
what is the size of ur database(like oracle)
which quality process u can approach in ur project
draw informatica architecture 8.6 ?
how to delete duplicate records by using filter transfermation?
Teradata 
