DSXchange

Hi,

Do you know what this error means?

Sequential_File_9,0: Field "Customer" with 'delim=end' did not consume entire input, at offset: 187

Thanks in advance.

Regards,
Deepa

Hi All, I am loading data from an SQL Server DB(using an ODBC Stage) to a Sequential File(.txt) through a Copy Stage. I am unable to view data from the SEQ File. I have given APT_DISABLE_COMBINATION as True,still it throws the following error: ##I IIS-DSEE-TFCN-00006 06:36:01(001) <main_program> con...

For example, I look up Product code as well as Country code from two instances of a table using one Lookup Stage.

Now suppose Product code finds a match and Country code does not, will it pass the matching record?

Hi,

Is it possible to use a single Lookup stage for looking up two tables and allow the records to pass if its finds a match in either of the tables.

In other words, I want an OR operation to work on the looked up columns and not an AND operation.

Thanks in advance.

Deepa

How do I turn off operator combination?

And also, how do I hardcode a value into a timestamp field.

Thanks in advance.

Deepa

Hi,

I am getting this error:

APT_CombinedOperatorController,0: Operator terminated abnormally: received signal SIGSEGV

How to rectify this?

Thanks in advance.

Deepa

Hi, I have two input tables Old and New. In the join stage, I am performing a Left Outer Join based on the common ID key. In the Output tab, under Mapping only one table appears i.e the Old table. I want the New Table columns also to appear. How do I do this? Both the tables have the exact same colu...

Thank you.

Deepa

Hi All,

I want to give this condition in the Constraint tab of Transformer:

C_ID IS NOT NULL AND A_ID IS NOT NULL

How do I give this in DataStage?

I want the Transformer to pass those records which don't have NULLs in their IDs.

Thanks in advance.

Deepa

Hi,

My source is a Database(RDBMS). It passes a Copy Stage then to Seq File(CurrentFile) and a CDC Stage. From CDC it goes to Target Seq File.
Comparison at the CDC Stage is done with another Seq File (PreviousFile).
Rejects from this file is sent to another Seq File.

Regards,
Deepa

Hi,

I do not know why they are getting rejected. I did use a Reject link to capture the rejected records. There is no pattern for rejection.

I used the command:

cp /filepath/CurrentFile.txt /filepath/PreviousFile.txt

Regards,
Deepa

Hi, I have two files-Current File and Previous File, present in a job. In the first run, all the records from the source get copied into the Current File and the Previous File is empty. Before the second run, I use the ExecSH command to copy the data from Current File to Previous File. While doing t...

Hi,

How to implement SCD Type 2, using SCD Stage, in a parallel job in DataStage 8.1?

Regards,
Deepa

I used a Sorter and in this stage, I changed the Partitioning in the Input tab to Round Robin, and selected the key based on which it should sort.

This resulted in ordered records in the target table.

Hey,

I used the manual method, but the records are not in order.

When I use the Sorter Stage, the records are still inserted into the target table in a jumbled manner. How to resolve this?

Thanks in advance.

Regards,
Deepa