how can u load the data in time dimension?

Question Posted / narasimha.inf

3 Answers
12317 Views
I also Faced
E-Mail Answers

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

How can you display only hidden files in UNIX

4 Answers Cognizant, L&T,

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 ?

1 Answers Wipro,

 Informatica Checkpoints

0 Answers DELL,

Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance

3 Answers

Hi can any one tell me the difference between persistence and dynamic caches? On which conditions we are using these caches?

3 Answers

Explain Dataware house architecture .how data flow from intial to end?

0 Answers Keane India Ltd,

Explain the scenario which compels informatica server to reject files?

0 Answers

what is song in infrmatica...?

0 Answers CTS,

Why is meant by direct and indirect loading options in sessions?

4 Answers

Mention few advantages of router transformation over filter transformation.