DSXchange

Hi MT,

Yes.I created only Primary keys for this table. (with TSPACE 32K).

Table has 230 columns and defined with 9keys. But out of 230 columns I am updating only few columns

I will post if any other information

Thanks

Hi,

I got the following results ..when I execute the above Query
Last week I was able to insert one record to the table with no issues but today I got the error when I re-run the job.

I am looking into this issue and will give more details

Thank you

Hi Chulett, The target table "SCHEMA.TABLE" has zero records. Table Action selected as "Append" Before SQL used=For Deletion of Existing Data Also I used Remove Duplicate stage to remove the duplicates before writing to target table. I hope this information is appropriate Thanks ...

Hi, I have a job scenario,where in I am inserting data into a table( INSERT STATEMENT) also I am using DELETE statement as BEFORE SQL. Getting the following error: DB2_XXXX: SQLExecute reported: SQLSTATE = 23505: Native Error Code = -803: Msg = [IBM][CLI Driver][DB2/AIX64] SQL0803N One or more value...

Thank you ray for the logic..It worked for me. Here is my output from the stagevariables based on the following order : svNewPreviousSalary <---- svPreviousSalary svPreviousSalary <---- InLink.salary EID Salary svNewPreviousSalary svPreviousSalary 100 1000 null 1000 200 1500 1000 1500 300 2000 1500 ...

Hello Everybody, I have a requirement to generate previous row value where first record should populate null . Input : Emp_ID salary 100 1000 200 1500 300 2000 Output: Emp_ID salary Previous_Salary 100 1000 NULL 200 1500 1000 300 2000 1500 I guess this can be performed by writing staging variables t...

Welcome Aboard As new to the Designer (Datastage) ..I would suggest to follow the help documentation for each stage (here Transformer stage) while working with stages . While editing the column derivation ,Right click on it then we see a option to insert "Input column" Ex:DSLink12.Entry No...

I was able to check the position of A's with my expression ..may be I need little more research before responding
Thanks

Index(InLink.TheColumn,"AAAA",1) Above Expression gives the position as 2 . This record can be captured as reject reject record if we check for occurrences whether Zero's or not (All Non-Zero values) Let me be clear with the requirement. If the column from the file has data NSAAAAI then t...

Observed the similar scenario: I have master sequencer"SEQMaster" calls sub-sequencer "SQ001" After I remove the parameter ($SAP_param) from the sequencer SQ001 and ran the master sequencer SEQMaster : I got below message : SEQMaster..JobControl (@SQ001): Controller problem: Erro...

Hi,

Tried with this statement

If (Len(Trim(InputColumn)) = 5 Or Len(Trim(InputColumn)) = 6) Then 1 Else InputColumn=0

Have Constraints in the transformer (InputColumn=0 OR 1) to verify the output

Thanks.

kduke wrote:I think it is very wise to plan a long term strategy like what industry you want to work in and what products you want to tie yourself to.

Thanks a lot everyone for the valuable suggestions

Thank you Ray,

It makes sense to me that understanding the data (metadata)is some thing different for different domains .. and as an ETL Developer role, the processing on the data is based on business requirements ..

Thanks Paul


I am looking at a technical point of view of data or methodologies ???

Hello Everyone,

Currently I thought of shifting to my domain Banking to Health care industry

Can you please share your thoughts or suggestions about the Health care industry ETL Processes ??