Interested to Buy Any Domain ? << Click Here >> for more details...
how can u load the data in time dimension?
- 3 Answers
- 12169 Views
- I also Faced
- E-Mail Answers
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 |
Is it possible to have "5 source & 5 Target" in single mapping?
What is lookup transformation?
How to load last 10 records of flat file in to the target?
Can we create a node as a gateway node and the same node can be assigned to a grid?
How we can create indexes after completing the load process?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
why we use stored procedure transformation?
Hi, This is Lakshmi,Anyone taking classes for datawarehouse-Informatica and BO with real time project
I have source data like this col1 col2 col3 5 3 8 6 2 9 7 1 10 and i want to get target as col1 col2 col3 5 1 8 6 2 9 7 3 10 which transformation i have to use and how?
How do you implement configuration management in Informatica?
what is difference between COM & DCOM?
How identifying bottlenecks in various components of informatica and resolving them?
Teradata 
