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!
-
Lookup Transformation Error
Hi, I am using a lookup transformation with the following SQL Override: SELECT MCIX.INVENTORY_ITEM_ID AS INVENTORY_ITEM_ID, MCIX.ATTRIBUTE1 AS ATTRIBUTE1, MCIX.ATTRIBUTE2 AS ATTRIBUTE2, MCI.CUSTOMER_ID AS CUSTOMER_ID, MCI.CUSTOMER_ITEM_NUMBER AS CUSTOMER_ITEM_NUMBER FROM MTL_CUSTOMER_ITEMS...- mckutlu
- Thread
- Replies: 1
- Forum: Data Management Tools general discussion
-
Stored Procedure Transformation
I am taking in 3 fields from a flat file (all strings), taking them into an expression transf. in which i convert one of the fields to "date/time" using to_date (with the format mm/dd/yyyy) and keeping the others as strings, and then mapping them into stored procedure transformation (with 2...- mckutlu
- Thread
- Replies: 1
- Forum: Data Management Tools general discussion
