how can u load the data in time dimension?

Answers were Sorted based on User's Feedback



how can u load the data in time dimension?..

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

how can u load the data in time dimension?..

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

how can u load the data in time dimension?..

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

Post New Answer

More Informatica Interview Questions

In session log thier should not be a single error how will u do

3 Answers   HCL,


By seeing the parameter file how do u identify wheather it is a workflow parameter or mapping parameter?

5 Answers   Keane India Ltd,


difference between informatica 8.1.1 and 8.6? And different betweeninformatica 7x and 8x?

1 Answers   HTC, TCS,


Difference between Data and Index Caches?

0 Answers   Informatica,


Tell me about Propagate functions in informatica

0 Answers  






tell me about your project functionality

0 Answers  


What are the different tools in workflow manager?

1 Answers  


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?

1 Answers   CTS, GE, TCS,


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

3 Answers   Wipro,


What is target update override

2 Answers   CTS,


How/where can i install Informatica software with oracle or teradata as database

0 Answers  


Categories