HOW TO YOU LOAD TIME DIMENSION



HOW TO YOU LOAD TIME DIMENSION..

Answer / rakesh

using stored procedure

Is This Answer Correct ?    6 Yes 1 No

Post New Answer

More Informatica Interview Questions

What could be the possible resons of locks by user?

0 Answers  


Performance wise which is better joiner or look up ? Give me with example?

1 Answers   CGI,


how can i invoke pmcmd in command line prompt

1 Answers  


if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

0 Answers   iGate,


is it reqire primary key and foreign key relation ship to join relational databases?if yes? explain?

3 Answers   IBM,






how lookup is acting as both active and passive ? how is it possitble?

9 Answers   TCS,


What is the difference between SOURCE and TARGET BASED COMMITS?

3 Answers   IBM,


Any one can tell me how to explain puss-down optimization ? explain me with example plz?

1 Answers  


In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the three dimensions by using one sequence generator is possible?If the mapping is containing single flow? And in the same case if the mapping is contaning 3 flows for the three dimensions then by using one sequence generator can we populate surrogate key (same value) to all the three dimensions?

6 Answers   IBM,


Can any one give me an example for factless fact table ? If your answer is studunt attendence registration,could you plese give me explanation for this ?

3 Answers   Cap Gemini, Puma, Wipro,


What is the difference between source qualifier transformations source filter to filter transformation?

0 Answers  


Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

0 Answers   Puma,


Categories