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...


A mapping contains

(1) Source Table S_Time ( Start_Year, End_Year )

(2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )



A mapping contains (1) Source Table S_Time ( Start_Year, End_Year ) (2) Target Table Tim_Dim (..

Answer / pati

Day = to_char(sysdate,'Day')
Date = to_char(sysdate,'DD')
Month = to_char(sysdate,'Month')
Year = to_char(sysdate,'YYYY')
Quater = to_char(sysdate,'Q')

Is This Answer Correct ?    3 Yes 2 No

Post New Answer

More Informatica Interview Questions

What are the challenges of Dataware housing in the future?

2 Answers   HP,


What are the data movement modes in informatcia?

3 Answers  


In which circumstances that informatica server creates Reject files?

2 Answers  


Can we create multiple integration service on single repository?

0 Answers  


server hot-ws270 is connect to Repository B. What does it mean?

0 Answers   Cognizant,


Enterprise data warehouse your projects phase by phase explain?

0 Answers   Cap Gemini,


Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..

1 Answers  


What are the types of maping wizards that r to be provided in Informatica?

2 Answers  


How to join a Flat and Relational Source without using (Joiner, Update and Lookup ) transformations... is it possible? if yes i would like to know how?

10 Answers   Wipro,


i have a data in my source as a flat files what test i have to perform the next step can any body help to me

0 Answers   SeeInfoBiz, TCS,


if i have source with 100 records target with 100 records and we lookup on another database table and it has 10 million record so what is the method of limiting that much record in lookup table?

2 Answers   TCS,


how to connect two or more table with single source qualifier?

4 Answers   IBM,


Categories