DSXchange

Connecting to data stage designer tool passing host name : abcd0012.cust.systems.co:9080 Project name: abcd:30012/cust_prd_proj While executing dsjob command Project name: cust_prd_proj server name:abcd0012 ${DSJob} -server abcd0012:30012 -domain -ljobs cust_prd_proj It is showing as syntax error Co...

yes we are able to open jobs. still facing the same.

I have re compiled the jobs, and also facing the same.

Initially, Tried with that one only. it is not working beacuse we using different port.
I have used the syntax. it list only 10 jobs but reamining 90 jobs it is showing the error message.

Hi, Total number of jobs in the project =100 10 jobs created with in the project 90 jobs exported with executables from the different environment and imported in this environment. ${DSJob} -server :30012 -ljobs project_name i am using the above command for listing all the jobs in the project. But it...

Hi, Hoping that using aggregator stage, performance is getting effect in the job. The job is running for 1hour for 1 million records. Near future we will get 5-10 million records . dataset --> transformer-->aggregator stage | Auto Partition V Input data is from a table--------------------> lookupsta...

i have got the work around on this. Now it looks fine.

Added a stage vaiable and placed the logic then used the stage variable in the derivation column. Now i am not getting the warning.


Thanks
SuRi

Hi, In the transformer stage, I am getting the following warning message: TransformerStage 0: Conversion error calling conversion routine timestamp_from_string data may have been lost Source column name: FutureDate Data type:Varchar (10) - nullable-YES Sample data: '1999-12-31' '1995-10-25' As per t...

Thanks ArndW for suggestion. Now the job performance is good. Job name: Cust_information Job design Sequential file stage1-->copy stage-->ODBC stage1(Table1) Sequential file stage2-->copy stage-->ODBC stage2(Table2) Sequential file stage3-->copy stage-->ODBC stage3(Table3) Sequential file stage4-->c...

Hi all, As i got information from the forms ODBC stage not good for loading bulk data. Data stage job running 10 hrs for 30 million records. i want to increase the performance of the job. Below i have tried the possibility options from the forms to increase the performance but still talking lot of t...

As per the suggestion, I have taken sample records and tested the job. Now the below records are populated successfully. "122","Chaina Asia","1234" "124"," london, united kingdom ","2222" But I have identified one record. As this is the add...

yes, I have give Quote is DOUBLE.


Field Defaults:
Delimiter=,
Quote=double

Thanks for valuable responses. As I am not premium member I am unable to see the ray wurold message. Notes from the chain responces. 1. We are not going to update the existing configuration file. 2. We will create a new configuration file. I have small clarification, can we assign configuration file...

Hi, Currently we are using 4 node configuration file. All nodes we are utilizing only for resource and scratch disk. Is their any possibility to use one of the nodes for database for fetching data from source/loading data into target (As we are using ODBC to connect to SQL Sever database). Remaining...

Hi, Job details: I have input file which is having 50,000 records and joining with 3 files(file1,file2,file3)based on single key. The output file contain 45,000 records and the reject link contains the 5,000 records. As per the process, I should get the 50,000 records but 5,000 records are rejected....