DSXchange

We Can Validate it using IsValid But How to abort the job using the IsValid function output

Hi,

My source is a flat file and I need to validate the date ,if date is valid then the process should flow else if date is invalid the job should abort.

Pl through some light,

Regards,
Rafidwh

Hi All,

My Input Date format is dd/mm/yyyy and I need to compare this input date with the current date.

How do I convert the input date to cuurent Date and do the comparisions.

Please through some light

Thanks in advance

Regards,
Rafidwh

Hi All, I am doing a lookup on a sequential file and the lookup file is also a sequential file,I am getting an error and the job gets aborted.The log shows: Lookup_3,2: Failed a keylookup for record. Lookup_3,2: The runLocally() of the operator failed. Lookup_3,2: Operator terminated abnormally: run...

Hi All, How to validate a source date. like if the source date is yyyymmdd,now i need to validate whether it is a eight digit and also in the correct format I mean if the date is like 20012020 and also it is null then I need to reject them. In a shell I can say that if date is invalid and null then ...

If we can use link collector on uniprocess server then how could the data is partitioned an dprocessed as in parallel jopbs the partitioned data flows in nodes.

Hi All,

Is it necessary that my DS server should be installed on a SMP or MPP if I need to use IPC or link collector stage.If not then then hiow the link partioner is partitioning its data and processing further.

Thanks in advance,
Saik.

Hi All,

I want to recruit QA team for Datastage what are all the criteria the testers require.

How do we test an ETL Datastage job,what are all the areas a tester should concentrate to test a job.

What are all the test cases he need to concentrate.

pl do the needful

Regards,
Saik.

Hi All,

I have two source files say SRCFILE A and SRCFILEB and thet target is also a flat file SRCFILEC.
now i need to combine these two files into the target file and everytime the records should append it should not overwrite.
Can anyone throw some light how to achive this.

Regards,
Saik.

The same error in different PC as well

well I used the same CD to install previously

While Ia m trying to copy the CD to my my folders it is giving me the error message saying "unable to copy some .DLL files"

I ma installing through a Installation CD

Hi All, I am trying to install Datastage on my own system.The server component is installed successfully but while trying to install client it is showing the following error and unable to install it. My OS is "XP PROFESSIONAL" and HARDWARE is in NTFS(drive) ERROR:Datatransfer error informa...

Any ideas Gurus