DSXchange

Also, you can read this as Char field and use MODIFY stage to convert into date.

complie the job, press run button and select validate option

Thanks Ray/kumar , your your suggestion.
i found the problem,there was a white space in the datastase name(i am paasing database name through parameter).

but i would like to know, the runtime column propagation should be enabled or disbaled?

how are you populating the EMP table, spcially what is the value you are passing to Deptno column, it must be range of 10-20;

PreviousWeekdayFromDate(CurrentDate(),'Sunday') will give you the result

you can create a group in unix server, crate a user, add him in this group and dstage group... in administrator assign this group as datastge operator for the project. for more detail read datastage adminstrator guide(Unix server administration)

its the same directory of your project.... every job has it's log in RT_LOG<xxxx> where xxxx is the job id, you can find this id by command LIST DS_JOBS <job name>.

you can achhieve it in many ways.but befoer that please give mpre details on your requirement.like metadata of source and target etc..

Its exactly same as the target table schema, infact i import the table metadata only.

the runtime column propagation is disabled.

i am getting this error while inserting into a teradata table..
any idea what is causing this problem?

sorry, i missed the double quote in the where clause

select
FundCode, PerfCode, Portfolio, "DATE" from
PERFORMANCE where CurrencyCode = 'AUD' and "DATE" >= '2006-06-06';

try this: select FundCode, PerfCode, Portfolio, "DATE" from PERFORMANCE where CurrencyCode = 'AUD' and Date >= '2006-06-06'; Make sure the column name in table is "DATE" not "Date", if the column name in table is "Date" then try select FundCode, PerfCode, Port...

i experienced, if you are not defining the APT_TERA_SYNC_DATABASE, then the terasync table is created at the same database of the base table..

Is there aby way to know, who is the last user/developer, who has change a particular already existing job.

Then add a join stage after the change capture stage, and join the Before dataset with the copy rows, to get other values from before dataset..