DSXchange

I am running on 2 nodes and am using the Auto Partition.

I am using the Change Data Capture stage to perform comparisons for the below 2 inputs and am getting different number of records for each run. For e.g. I get 2 records or 3 or 1 record as output when I run each time: Can some one please help me as to why this is happening. Thank you Input 1 Key id_...

Exactly.

ID is being generated in the transformer.
It is a requirement thats why we need to populate the ID COlumn in both tables.

My job looks like: File -> Xfrm -> ODBC or DRS Stage Table A has ID, Name Columns Table B has ID Column. In the ODBC or DRS Stage: I want to first insert records into Table A. After populating Table A I want to insert records into Table B based on the records that have been inserted into Table A (I...

Hello,

I want to perform a Insert into one table (A) and based upon the Insert values in the first table (A) Update the second table (B).

Can I accomplish this using one stage like the ODBC or DRS Stage instead of 2 seperate jobs?
Database that I am using is SQL Server.

Anbu,

Thank you very much for your help. It worked fine.

I have a target database with the below 2 fields. Field 1 has unique numbers. E.g. Field 1 Field 2 1 abc 2 def 3 ghi I have a requirement wherin I need to insert records into this table. I need to first look at the last number in field 1 and insert records starting from 4 onwards. How do I achieve t...

Yes I am using RCP.

To isolate the field for which I was getting the error, tried dropping the field: FIELD12 NVARCHAR(2000) and I am not getting any error and the target table is getting populated.

How can I handle nvarchar(2000)?

I have not defined any column definition explicitly in my job. I got this from the database to give an idea about the fields I am dealing with.

Ray, Below is my input column definition for the table that is not loading: FIELD1 DECIMAL(5,0) NOT NULL ,FIELD2 DECIMAL(10,0) NOT NULL ,FIELD3 NVARCHAR(2) NULL ,FIELD4 DATETIME NULL ,FIELD5 DECIMAL(10,0) DEFAULT 0 ,FIELD6 DECIMAL(5,0) NULL ,FIELD7 DECIMAL(10,0) NULL ,FIELD8 NVARCHAR(30) NULL ,FIELD...

Hello, I am reading a SQL Server DB Table and am loading another table on SQL Server DB. Below is the job flow: ODBC -> Copy -> ODBC I have a problem wherein I get the below error for some tables and the rest of the tables seem to be loaded fine. I have not defined any column definition explicitly a...

Can we drop a table using a DataStage Job?
Database where the table resides is a SQL Server.

Transformer_45,0: Conversion error calling conversion routine date_from_string data may have been lost