DSXchange

Datatype selected was longnvarchar and the sizedefined is too long..
Did neone find the solution
Its urgent

Hi all I am doing a look up from the ODBC connector component and trying to read the value of column A. Column 'A' is a longnvarchar but datastage is not able to read it , it is throwing an error. I tried setting the environment variable APT_DEFAULT_TRANSPORT_BLOCK_SIZE to its maximum value but it d...

I am using basic routines, is there any build in function where i can find if the given job, or given transformer has any constraints lets say I have a transformer name from one of my jobs, can i find if it has any constraints defined in any of its links

Hi,
While importing datastage job into my server
I got below error.

datastageserver version:8.0


Error:

Missing Identifier in job/exec job section
object: =
class=:job design

can anyone please help me ?

Regards,
thanks.

Hi All,

I had tried with copy stage between look up and DB2 stage. I think, the issue with partition clause in DB2 Ref Query and Data Stage partition.

Please let me know if you need any other information.

Can anyone throw some light on this.


Thanks in advance.

My guess... Enable 'returns multiple rows' in lookup and set the missing option as 'continue'. Is it you who developed the job? Maybe you can shed more light on what you need to achieve. Hi All, As you suggested, I enabled 'return multiple rows' and set the missing option 'continue'.It did not work...

Hi All, I wanted to perform some testing on one of existing jobs.In that job, source is a sequential file. They wanted to perform look up on DB2 table. Reference table query: SELECT LTRIM(RTRIM(VEH_IDENT_NBR)), LTRIM(RTRIM(SRC_TXN_ID)), SRC_VER_NBR , TRANSACTION_ID, RANK() OVER (PARTITION BY SRC_TXN...

Hi All, I am using Complex flat file stage to read complex flat file data from unix.I have put record type as Fixed,Missing file mode as Depends and Reject mode as Continue.As per my job design,CFF stage expects record length of 1521.However One particular record has only 613 at source. While readin...

Hi All, we have server shared container(ErrorHandlingContainerPSct) in dev environment. I want to import the new parallel shared container (ErrorHandlingContainerPSct) from prod to dev. For that, I want to delete the existing server shared container ErrorHandlingContainerPSct. It gives error like &q...

hi
how to check automatically all three files (including produt,geo,bas) are present are in the FTP server and to validate that each file's stats agree with manifest stats (both count and bytes must match) before the ETL process begins

Ability to manage and control access and usage of ETL processes based on user role - Admin, Developer, or Operator - Managed Manually in datastage any please help me
thanks
koti

hi

Ability to send notification based on missing file or invalid stats if files missing and/or invalid stats
in datastage

hi

Ability to send notification based on missing file or invalid stats if files missing and/or invalid stats

hoe to do that
thans koti

Ability to manage and control access and usage of ETL processes based on user role - Admin, Developer, or Operator - Managed Manually

A number of columns used to process the dimensions (such as src_key columns) do not have indexes. Since lookups use these columns extensively, adding indexes will greatly speed up loading performance.