DSXchange

Hi,


I have a confusion, what is the main difference between Lookup and Join Stage.




Regards,
Vinodn

Hi All,


Thanx for ur feedback,i resolved this problem.



Regards,
vinodn

Hi, While using the job parameter as input file to read,at the time of compiling its ok,but at the time of running it gives the following error: Unable to open E:/files#targetfile.txt#: No such file or directory [new-impexp\file_import.C:2469] Sequential_File_0,0: Operator's runLocally() failed. [ap...

Hi All,

Pls help me for this query.



Regards,
Vinodn

Hi all I am using Datastage EE (7.5) I am trying to read the data from an ODBC Enterprise stage and pass it to a transformer and then write it into a ODBC Enterprise stage ODBC Enterprise-->Transformer-->ODBC Enterprise I am giving the write mode as "WRITE". Compilation was ok. But while r...

Hi Arndw,

I tried for all the ways watever u told,but i will get same error agian.
Atlast i uninstall the software agian i installed in C-drive know its working
Fine.

Thanks for ur replies.



Regards,
Vinodn

Hi ArndW, This is the my default.apt file: { node "node1" { fastname "IITBOMBA-RCBGR8" pools "" resource disk "E:/Ascential/DataStage/Datasets" { pools "" } resource scratchdisk "E:/Ascential/DataStage/Scratch" { pools "" } } }

Hi,

I created TMP Folder in F_drive because i installed datastage in that drive.
I dont know if the process is correct or wrong.Pls help me for this query.
How can i get temp file and how to create that File.


Thanks

Thanx for ur reply,

I created TMP file,But the problem can not resolved.
i am getting same error again,actually i installed datastage in F-Drive in Windows 2003 environment.
If any alternate process send me.


Thanks

Regards,
Vonid

I cannot able to view the data after loading in sequential stage or oracle stage in Parallel.But no problems with the server.It shows the following error.Please anyone kindly help me how to resolve this problem. ##I TOSH 000002 18:33:33(001) <main_program> orchgeneral: loaded ##I TOSH 000002 18:33:3...

i have taken meta data for the 4 columns in the Target oracle stage as varchar(1300),varchar(1300),varchar(1300),varchar(1300) and respective Target table columns (oracle data base) data type as Varchar2(1500),Varchar2(1500),Varchar2(1500),Varchar2(1500), i ran the job, it is fine and data also geet...

To answer the question asked - yes, of course. but when i ran the job i am getting the below error in the datastage esql complaint: ORA-01461: can bind a LONG value only for insert into a LONG column all source columns data type is varchar(1500) and respective target columns datatype is varchar2(15...

Hi all, in my source 4 columns data type is varchar(1500)---SQL server Target 4 columns data type is Varchar2(1500)--Oracle when i ran the job i am getting the as error ora:1461 LONG data type value is not insert in to another data type value, if i take the target columns meta data in target stage(o...

Hi All, Trying to load Source column data type varchar2(4000)---Sql server Target column data type is Varchar2(4000)---Oracle, Datastage throws an error with the following ORA_AUWREQUESTRESPONSE_Tab,0: Array execute failed for insert: insert is: INSERT INTO AUWREQUESTRESPONSE (AUWHISTORYID, REQUEST,...

Hi All, I am using the following properties in my Oracle Stage. Write Method = Load Write Mode = Truncate What would be sequence first Whether it truncate all the records first and then Load. Do we have any commit intervals using truncate and Load. This clarification is needed as i got very less SLA...