how can u load the data in time dimension?

Question Posted / narasimha.inf

3 Answers
12334 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how can u load the data in time dimension?..

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

how can u load the data in time dimension?..

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

how can u load the data in time dimension?..

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

Post New Answer

More Informatica Interview Questions

What is meta data and system catalog?

2 Answers

How do you create single lookup transformation using multiple tables?

6 Answers TCS,

Without using any transformations how u can load the data into target?

15 Answers IBM,

without update strategy how to insert &update?

1 Answers DELL,

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

0 Answers

when i was running the seesion, after loading 100 records, session suddenly fails.Next time i want to load the remaing rows in target with out truncate target table.What should i use?

7 Answers Cegedim, IBM, TCS,

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

0 Answers Infotech,

what is mean by throghput? in informatica

3 Answers Cap Gemini,

How do you Merge multiple Flat files for example 100 flat files with out using Union T/F

4 Answers IBM,

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

0 Answers TCS,

Plz..let me know differences between Informatica 7.1 and 8.1?

3 Answers

follwing scenario two table using find maximum salary? table a table b 101 xxx 1000 106 6500 103 yyy 5000 108 800 104 din 6000 109 7000 105 dsh 200 110 3000

5 Answers IBM,

For more Informatica Interview Questions Click Here