how can u load the data in time dimension?
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 |
In session log thier should not be a single error how will u do
By seeing the parameter file how do u identify wheather it is a workflow parameter or mapping parameter?
difference between informatica 8.1.1 and 8.6? And different betweeninformatica 7x and 8x?
Difference between Data and Index Caches?
Tell me about Propagate functions in informatica
tell me about your project functionality
What are the different tools in workflow manager?
we have tables like c1 a c2 b c3 c c4 x c5 y and i need output like abcx in a single row and abcy in a single row? how do u do this?
2 Answers Patni, Tech Mahindra,
What is Performance tuning in Informatica?
There are 4 source files which contains same metadata create target that should display the file name along with record please send answer with mapping
What is target update override
How/where can i install Informatica software with oracle or teradata as database