Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: anant123
- Order by date
-
date/time format
to_date('270996','ddmmyy') Or you can use substr to break the dd, mm, yy into individual components and then use concat to concatenate them in the desired format . At the end use the to_date command to put it into date format. a = 270996 (of char type) dd = substr(a,1,2); mm = subst(3,2); yy =...- anant123
- Post #2
- Forum: Data Management Tools general discussion
-
Update Strategy
Hi, What papagari meant is that you must be connecting the 'ID' field from lookup transformation to the update transformation. If so then DONT DO THAT. You must be having some Expression Transformation before Lookup Transformation which is passing the 'ID' field to LOOKUP. Use this Field (from...- anant123
- Post #5
- Forum: Data Management Tools general discussion
