Interested to Buy Any Domain ? << Click Here >> for more details...
how can u load the data in time dimension?
- 3 Answers
- 12113 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 |
While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?
how many repositories can v create in informatica .
3 Answers Cap Gemini, Tech Mahindra,
I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records
Explain the different lookup methods used in informatica?
how do u move the code from development to production?
What is the difference between Connected and UnConnected Lookup Transformation.Give me one or two examples please?
How do you convert single row from source into three rows into target?
How i can upload the MainFrame source For Informatica ?
If you have 10 mappings designed and you need to implement some chages (may be in existing mapping or new mapping need to be designed) then how much time it takes from easier to complex?
Explain sessions and how many types of sessions are there?
How can a transformation be made reusable?
What are ETL Tools?
Teradata 
