Interested to Buy Any Domain ? << Click Here >> for more details...
how can u load the data in time dimension?
- 3 Answers
- 12301 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 |
Which transformation should we use to normalize the COBOL and relational sources?
4 Answers DELL, IBM, Lehman Brothers,
If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?
If I have set the property Treat Source Rows as Insert and for the target properties I have checked the boxes Update as Update, what will happen to incoming rows? What exactly is the use of these check boxes and in which scenarios we use them. Also what is the sequence in which informatica understands these properties.Does it takes whatever is defined in treat source rows as property or it is in any other way. Please explain.
On which transformations you created partitions in your project?
my table contain duplicate Records i wanna load uniq records to my table . i have to pass the uniq records through filter t/r how?
What is meant by target load plan?
What is A cache?
what is the command to get the list of files in a directory in unix?
What are the reusable transforamtions?
wt is the difference between truncate and delete in which situation u use delete and truncate in real time..
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
What is a joiner transformation and why it is an active one?
Teradata 
