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

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

0 Answers   IBM,


How do schedule a workflow in Informatica thrice in a day? Like run the workflow at 3am, 5am and 4pm?

3 Answers   Logica CMG,


How to update source definition?

0 Answers  


Partition, what happens if the specified key range is shorter and longer

0 Answers   Cap Gemini,


what is the difference between onsite & client site?

1 Answers  






i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c i want output as 1 a,b,c and 2 a,b,c ... how can achieve this

5 Answers   TCS,


Design a mapping to load the cumulative sum of salaries of employees into target table?

0 Answers   Informatica,


how to get max value record into one target and remaining records into another target?

2 Answers   Accenture,


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

1 Answers   HTC, TCS,


How can we get two output ports in un-connect transformation?

2 Answers   Ness Technologies,


My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?

3 Answers  


what are the perameter and variable?

3 Answers   IBM,


Categories