DSXchange

Hi, Thanks, I have loaded data into the time dimension table ( Date_SK (PK, int, not null) Date (varchar(8), null) Month_Number(int,null) Qtr_Number(int, null) Year_Number(int,null) I have transaction table Policy with following fields PolicyNumber, Premium_Amount, Region, payment_Date. How do I loa...

Hi,

I checked my job logs for last four days.

The job ran without any warning message.

Where do i look for
"Reset if required then run" options in my jobs?

Ketfos

Hi,

What calculations I need to build into the Excel for time dimesnion .
Loading from Excel to table is not a problem.

ketfos

Hi, I have a job scheduled to run at 9.00 am in the morning. I got this warning message in the error log Job IClaimsPolicyKeyUpdate must be reset before it can run. The source reads the target table for policyid is null. The action is to concatenate policyNumber and POlicyYear and populate it to pol...

Hi, I have transaction table with Policy Number, Location, Type, Premium Amount and Payment Date. I want to create FACT and DIMESNION table. I want to create a Fact Table which will have premium amount and corresponding Time Dimension table to analyze this fact on daily, monthly,quaterly and yearly ...

Hi,

I have Oracle database.

How do I load data into time dimension.
The measures are day, month, qtr, year.
We have datastage 7.5



Thks
Ketfos

Hi,

One simple way is to put a REJECT constraint in the transformer and write the output of REJECT constraint link to a file.

All the rejected rows will be written to a sequentila file.

Ketfos

Hi, hJobU2PM23 is the job handle from DSattach function for job named Updatejob ErrCode = DSWaitForJob(hJobU2PM23) Status = DSGetJobInfo(hJobU2PM23, DSJ.JOBSTATUS) If Status = DSJS.RUNFAILED Then * Fatal Error - No Return Call DSLogFatal("Job Failed: Updatejob", "JobControl") End...

Hi, I am reading from seq file and writing to Oracle table. The number of input records is 12 million. The action is set to Update/Insert. Array size is 400, transcation size = 0, transaction handling = 10000 I am getting like 60 rows/sec. Seqfile - Transformer - Oracle table. Any clues/suggestions ...

Hi, I am reading from Unix Sequential file - fixed width format and writing to Oracle table. I am getting an error while I am writing to the table. LoadStage.MPNO.InRecord: read_fixedwidth() - row 53161308, column TXT, column unexpectedly ended by EOR The total number of records in the input file ar...

Hi, I am reading from Unix Sequential file - fixed width format and writing to Oracle table. I am getting an error while I am writing to the table. LoadStage.MPNO.InRecord: read_fixedwidth() - row 53161308, column TXT, column unexpectedly ended by EOR The total number of records in the input file ar...

Hi, Your suggestion did help and now I not getting the previous error message "is not supported for pre-defined update action. " The error message is ORA-01036: illegal variable name/number The user defined sql in target table -Oracle INSERT INTO TESTPAY (POLICY_NUMBER,POLICY_YEAR,POLICY_S...

Hi, Below is the user defined sql for insert into target table. TestPol..SchemaTABLENAMEACTION: INSERT INTO POLICY(POLICY_NUMBER,POLICY_YEAR,POLICY_SUFFIX,GROUP_NUMBER,BILL_TYPE,BILL_ACCOUNT_TYPE, POSTING_DATE, PAYMENT_DATE, PAYMENT_AMOUNT, PAYROLL_FROM_DATE, PAYROLL_TO_DATE, ALLOC_FROM_INITIAL_PREM...

Hi, I am using Oracle 9i and Datastage 7.5 Sever Edition. When I write a user defined sql for inserting into target table (Oracle) and update action is User -defined sql, and run the job, it gives warning message is not supported for pre-defined update action. The source is Oracle table. Is user def...

Hi, No there is no trailing comma as shown below VALUES (:1,:2,:3,:4,:5,:6, TO_timestamp(:7, 'YYYY-MM-DD HH24:MI:SS:FF'), TO_DATE(:8, 'YYYY-MM-DD HH24:MI:SS'), :9, TO_DATE(:10, 'YYYY-MM-DD HH24:MI:SS'), TO_DATE(:11, 'YYYY-MM-DD HH24:MI:SS'), :12,:13,:14,:15, TO_DATE(:16, 'YYYY-MM-DD HH24:MI:SS')); k...