Bulk Copy insert
-
Hi Guyz, We have MS DTS for doing all sort of data transformation from almost any kind of data source to any other data source. It is such a power full tool. We also got utilities like BCP which shipped along with MS Sql server. My question is do we have any such tools for oracle where i can bulk insert records with alot of custom transformations and all. thanks Venkat Cheers, Venkatraman Kalyanam Bangalore - India "Being Excellent is not a skill, it is an attitude" Reality is an illusion caused by caffeine deficiency(one Microsoft Research scholor)
-
Hi Guyz, We have MS DTS for doing all sort of data transformation from almost any kind of data source to any other data source. It is such a power full tool. We also got utilities like BCP which shipped along with MS Sql server. My question is do we have any such tools for oracle where i can bulk insert records with alot of custom transformations and all. thanks Venkat Cheers, Venkatraman Kalyanam Bangalore - India "Being Excellent is not a skill, it is an attitude" Reality is an illusion caused by caffeine deficiency(one Microsoft Research scholor)
-
Ravish wrote: Use Informatica My initial thought about Informatica is "it is a kind of reporting tool for OLAP reporting". Can you give me more information regarding the same and how it can help me doing all Transformations and custom validation while transforming data from one data source to the another. Cheers, Venkatraman Kalyanam Chennai - India "Being Excellent is not a skill, it is an attitude" Reality is an illusion caused by caffeine deficiency(one Microsoft Research scholor)