Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


every DWH must have time dimension
so now what is the use of the time dimension
how we can calculate sales for one month,half-yr'ly,and
year'ly?how we are doing this using time dimension.



every DWH must have time dimension so now what is the use of the time dimension how we can calcu..

Answer / ravi

BY TAKING THE TIME DIMENSION TO EXPRESSION TRANSFORMATION
AND CREATE NEW PORTS AND MAKE THE NEW PORTS AS OUTPUT PORTS

WRITE CONDITION IN THE NEW PORTS BY USING THE FUNCTION
GETDATE_PART(DATE DIMENSION)

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Informatica Interview Questions

What is workflow variable? When we use workflow variable? Can any one explain me with one example???

2 Answers   TCS,


HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

0 Answers  


how eliminate the duplicates in flat file with out using sorter ,aggregater

4 Answers   Wipro,


What are the mapping parameters and mapping variables?

0 Answers   Informatica,


What is a stored procedure transformation?

0 Answers  


What is the difference between normal and bulk loading? Which one is recommended?

1 Answers  


Can you please mail me a copy of Informatica Certification Exam dumps to r_balakrishna@yahoo.com

21 Answers  


which transformation uses cache?

3 Answers   Keane India Ltd,


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

3 Answers  


CAN WE IMPLEMENT SCD TYPE 1 AND SCD TYPE 2 IN SAME MAPPING? IF SO HOW?

6 Answers  


Can you start a session inside a batch individually?

2 Answers  


What are the features of complex mapping?

0 Answers  


Categories