I recently learned Informatica(INFA) and started having hands on experiance with it. I wanted to share some of my INFA experiances/issues/solution with all.
RTrim or LTrim takes a parameter which can be a specific string. If the string contains the specified one it trims(deletes) from the actual string given, else leaves it as it is.
For Example: I had a date pattern like '7/8/2006 0:00:00'. I used the RTrim expression as below:
RTRIM(In_str, '0:00:00')
The output of above is '7/8/2006'.
Will publish more as I come across.
12 comments:
got you...I explained the things here
Data Warehousing | Informatica | Oracle | Unix Tutorial
That's a good example. But, in real time LTRIM and RTRIM will be used to make the filed accurate by removing the spaces to the left and right and most of the date convertions are handled by the TO_DATE Fucntion.
All the best.
Sharing for sharings sake is a rare trait.Keep up the effort
Appreciate your efforts Shireesha,
My recent post etl tools
And Dynamic parameter file
Nice to see people online and sharing through blog.
plz review my recent post ETL Tools
and Dynamic Parameter File
Iam really satisfy by your information.
It's well-written, to the point, and relative to what I do.
I like it very much for giving information on
Excellent Informatica Online Training .
This is nice blog and thanks share with us.we providing Informatica online training
The information which you have provided is very good and easily understood.
It is very useful who is looking for informatica Online Training.
Thanks for sharing the valuable information,This is useful information for online learners
AB INITIO Online Training
hi,you have to sharing for lot of information....i hove to very like that yourinformation..Excellent blogs!!!hadoop training in chennai
thank you for sharing the valiable information Azure Online Training
Very valuable information provided, folks will be getting good knowledge Informatica online training
Post a Comment