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

how to join two flat files in informatica?

3 Answers   Wipro,


How to identify this row for insert and this row for update in dynamic lookup cache

3 Answers   CSC,


what are presession,postsession success and postsession failure commands ?

1 Answers  


can we load the data with out a primary key of a table? what is target plan?

6 Answers   IBM,


when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/

5 Answers   L&T,


tell me 5 session failure in real time how can you solve that in your project?

0 Answers   CSC,


wf dont have integration severances how you can run?

0 Answers   TCS,


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  


Define sessions in informatica etl?

0 Answers  


What is a surrogate key?

0 Answers  


What are the session parameters?

3 Answers  


what is worklet and what use of worklet and in which situation we can use it?

4 Answers   Patni, TCS,


Categories