DSXchange

Hi:

I am gettting the date from source oracle as mm/dd/yyyy.
I need a same format in the target also.
In the target SQLServer we have Datetime.

Please let me know the conversion syntax in the transformer.

Thanks
cnu

Hi:
the error is select privileges.
I will work with DBA on that.

Thanks
cnu

Hi:
the error is select privileges.
I will work with DBA on that.

Thanks
cnu

Hi Thanks !!
Added the Server and specify the user name and passowrd also as user=user,password=password.It fail to connect when i click on View Data button.
But i am able to connect to the database by using same.
Is that way of passing user and password is correct.Please advice me.

Thanks
cnu

Hi: I am using the Oracle enterprise stage tp read the daya from Oracle database.I am wondering where can give the server name in the stage. In the properties tab there is DB Options and DB Options mode. I am using the Userdefined SQL option. In DB Option there is User and password only to enter. Wh...

Thanks !!

Hi:
Target stage Database is SQL Server.
I did't find the SQL server stage in Datastage7.5 Version.
Please let me know which stage can i use to load the data in the target table.

Thanks in Advance
Cnu

Hi :

I am using the Storedprocedure stage between the transformer and join stage.
Calling the stored procedure,while running it giving a following error.

Error occurred in call to ORPHCallActivePluginInitialize().

Thanks in advance
cnu

Hi:
The problem is resolved.

Thanks
cnu

Hi:
Thank for quick response.

Source is Sequential file,target is sybase.
Target column defiend as timestamp.

Thanks
cnu

Hi:
Thank for quick response.

Source is Sequential file,target is sybase.
Target column defiend as timestamp.

Thanks
cnu

Hi:

Date is coming like 5/10/2008 from the source.in the target has a column as timestamp .
But my requirement is load the date which is coming from the source 5/10/2008 to the target.Can you let me know how i can transfer in the transformer.

Thanks
cnu

Hi Craig Hulett :

For the scheduling Job from the director cron and cron tab is required right?

Thanks
cnu

Hi:

I want 19 when year from source is 99,98,90 etc.when ever sourc year is
08,07,03 etc it should pass 20 .

Please how can i resolve this requiremt.

Thanks
cnu

Hi: I am loading the data from flat file and load the data in sqlserver target table. My requirement is insert the record,if already record is there uodate the record without duplicate inserting or record. Which stage can use in the target side.Database is sqlserver. And please let me know which opt...