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 |
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
How do schedule a workflow in Informatica thrice in a day? Like run the workflow at 3am, 5am and 4pm?
How to update source definition?
Partition, what happens if the specified key range is shorter and longer
what is the difference between onsite & client site?
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
Design a mapping to load the cumulative sum of salaries of employees into target table?
how to get max value record into one target and remaining records into another target?
difference between informatica 8.1.1 and 8.6? And different betweeninformatica 7x and 8x?
How can we get two output ports in un-connect transformation?
My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?
what are the perameter and variable?