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

i have a source which relational.I am trying to populate to
target flat file with one column for daily date which is
sysdate.
I want to populate the sysdate coulmn with DD/MM/YYYY
format.
kindly provide a solution for this..my clear that my target
is flat file.

Answer Posted / prabhas

In expression transformation create one out put port, and
write like: TO_DATE('SYSDATE'.'DD/MM/YYYY').
Connect this port to target.

Is This Answer Correct ?    7 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

The question was on time stamp. what is the difference between HH and HH24 when to use when.

2039


Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

2048


which one is better performance wise joiner or look up

1073


Explain Dataware house architecture .how data flow from intial to end?

2574


What is a predefined event?

1082


What is substr in informatica?

1181


What are the limitations of joiner transformation?

1092


What are the features of complex mapping?

1146


How would you copy the content of one repository to another repository?

996


Explain what are the different versions of informatica?

1083


How to elaborate tracing level?

1155


What is informatica metadata and where is it stored?

979


What is aggregate cache in aggregator transformation?

1126


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

1949


How to create Target definition for flat files?

1198