DSXchange

U CAN USE ODBC OR RDBMS

How can we increase the buffer size in the stages like lookup , TX ,CDC

any suggestion will be helpful

MAY BE U SHOULD TRY FIXED WIDTH OPTION

the solution what i found is we can split the job and run it and it worked fine but the issue is its taking more time this will be gud for one time initial load

Hi

i am getting this "Lookup_459,0: Fatal Error: fstat() failed: Object is too large for operation" error i am using sqlserver

can any one help
thanks
Sameer

delimeter i am using is pipe

Hi
i am running a job in parallel it is getting aborted and giving this fatal "Consumed more than 100000 bytes looking for record delimiter; aborting" i am using SQLserver my job contains change capture and lookup.

Plz help
sam

Hi
i am running a job in parallel it is getting aborted and giving this fatal "Consumed more than 100000 bytes looking for record delimiter; aborting" i am using SQLserver my job contains change capture and lookup.

Plz help
sam

i have a look up which is joining a table that contain 40 million records with the input sequential file that contain same no. of records but when it reaches to this look up it is getting failed error i am gettin is "unable to operate on large objects"

please help
thanks

hi meena
my job has 2 lookup and size of file is 40 gb .

when i am running th ejob i am getting error as scratch space full and my job is getting aborted. i got hint from dsxchange that we need to increase the scratch space but i dont know where i will find that option in data stage

how to monitor the scratch space and how to increase the size
i am using sql server

can any one plz help me out
thanks

Hi meena i cant find this error in search

Hi i am getting this fatal ''Parallel job reports failure (code 139)'' can i anyone help .

thanx

Hi

i am getting error as compile.tmp not find while compiling i am using SQL SERVER .

thanx