Interested to Buy Any Domain ? << Click Here >> for more details...
how can u load the data in time dimension?
- 3 Answers
- 12290 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 |
I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?
List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys
suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping using aggregator & router? how
What is mapping debugger?
EXL informatica Questions
how will u get 1 and 3rd and 5th records in table what is the query in oracle please help me
How to load a relational source into file taget?
What is partioning?how many types of partinings are there
How do you take care of security using a repository manager
What is confirmed dimension with scenario
Teradata 
