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 )

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

1093


What is a surrogate key?

1091


What does command task mean?

1159


Can you use flat files in Mapplets.

2660


What is joiner change?

1154


How to do the error handling of if ur source is flatfiles?

1975


How to use procedural logic inside infromatica?

1252


Why union transformation is an active transformation?

1053


complex mapping ur project u r invlve can u explain and give real time example give me ?

2312


What is the use of an aggregator cache file?

1205


Differentiate between sessions and batches?

1025


what is the complex transformation you used in informatica

2594


Can we get 1st record through Informatica(without sequence number).

1488


What is pmcmd command?

1132


Define update strategy?

1235