DSXchange

I am also thinking of another approach.

1. Keep update action in CDC job.
2. Load inserts into a dataset.
3. Build a generic load job with RCP & parameterise dataset file name & table name.
4. Use load RCP job for all inserts.

Thanks for your reply chulett. Sure, i will test in both the ways.If performance is same in both the ways, then i would like to build insert/update actions in CDC job. I am seeing following advantages in this way. 1. If suppose i have 100 tables, then if i need to build separate jobs for inserts/upd...

Hi All, We are trying to build a new data warehouse, i am currently doing POC, we will have multiple tables in warehouse, we will build CDC job for every table to capture the data changes. In every CDC job i am planning to capture inserts into a dataset & edits into another data set. Next i plan...

Thanks for the reply ray, if nothing works i would like to create views in database. I have little hope on datarules in IA, but i never used them. May i know, can we create datarules to join two tables and for column analysis.

SV1: Right(YearFromDate(CurrentDate()),2)
SV2: If Input <=SV1 then '20':Input Else '19':Input

Mostly we uses this logic, i hope it will solve your problem....

Hi, I am new to Information Analyzer, i started working on column analysis, virtual columns and virtual tables. I am facing one problem, I am trying to perform join on two tables and next column analysis on select fields. I am not able to join two tables while creating virtual tables. Could anyone p...

You can get ur results from following stage variables.

sv1: MonthFromDate(input_date)/3
sv2: Ceil(sv1)
sv3: 'Q' : sv2 : YearFromDate(input_date) [3,2]

Hi All, I have a issue, and i tried myself to trace the problem but it didn't work. Issue:- I have a px job and have 3 environments(Dev, Test, Stage). Job running fine in Dev and Test, but it's keep on failing in Stage with below fatal error. [IIS-CONN-DB2-000004] DB2 function SQLConnect failed: SQL...

DfloatToDecimal Then pass decimal to BigInt.

I am also tried with force compilation also. i hope i need to compile shared container, but there is no option to do it.

Hi, I am using one shared container in one of my job, after completion of 2 or 3 runs of job, i found one issue in shared container and modified it and saved. Now i am not able to run the job from designer, it is giving one message like 'The following referenced Shared Container(s) have been modifie...

Hai, I have a problem while designing sequence job. My flow is like below Exec1====>Exec2===>Exec3===>Exec4 Here i am executing one shell script with multiple parameters using 4 executecommand stages. if exce1 is successfully completd then Exec2 will start.and exec3 and exec4 also depend on the succ...

Hi , I have a situation wherein I need to use the same Sequential file as the source , do some transformations and then load this data into the same sequential file which will have the updated data for the next run. Please help... :) Create 2 jobs ,in first job take one temporary file as target and...

stefanfrost1 wrote:try

effdate_out:date=date_from_string["%dd/%mm/%yyyy"](effdate_in)

Hi Stefan ,

Thank u a ton.it is working now.

Hi, I am facing one problem while converting date format.First my source is a fixed width file.one of my column contain date type records, but i am reading it using char data type.My sourec is 10120/01/2007aaa 10212/12/2007bbb metadata: id char(3) effdate char(10) name char(3) In file date is in dd/...