DSXchange

HI I am getting many warnings while running my job for seq. file stage Measure_code,0: Delimiter for field "ZZPA_M001_RKF008" not found; input: {G _ A V}, at offset: 153 [impexp/group_comp.C:5775] I have checked in my file delimiter is present for field value. Any suggestion how to remove...

Hi gurus, I need a suggestion or solution in a design for which Source is a data set and target is Oracle. The meta data of dataset and the Oracle table is same. When the dataset is being created with any invalid data to the corresponding data type, some ****** values are assigned to them. Now, bef...

Then.......
Can you give detail about the job structure, source ,transformation (if any), Target database..

Do you want to load all the three files into one table, If yes u can use file pattern!!

devesh_ssingh wrote: i have to form a loop through which oldest file should come first, then newest and recent.


Regards,
Devesh

What exactly you are doing with the files, just moving or extracting ???

The jobs are not moved anywhere!! A script should be sheduled in the ControlM ,which calls the datastage jobs

Use Aggregate stage to count rows on key column,
In Transformer ,if it is graeter than one ,load it error table else in the table you required

Post the syntax you used for the function, Also post the output you are getting!

I deployed two jobs,
One to update the Oracle table from Netezza Table
second to update null value to zero in Oracle table

I am working around with some more option..... to do it in one job

I'm not clear on the mapping, but consider using Oracle left outer join to netezza and NullToZero(value from netezza). lets consider Table Tab_A, ID COL_A 1 199 2 299 3 399 Table Tab_B ID COL_B 1 NULL 2 NULL 3 NULL 4 NULL ... Need to update the table Tab_B from Tab_A, Tab_B should be, ID COL_B 1 19...

HI, My requirement is to update a COLUMN in oracle table from the value from netezza table. The job is running fine and updates the value with respective id. If an id is not in my netezza table , the column was left as null value. Now i need to update values if the id is present in source else need ...

videsh77 wrote:

How can I be able to get rid of these warnings, with the identification of from which stage it has originated ?

Set APT_DISABLE_COMBINATION to True

Set Warning limit to No limit while running the job.,else you can use message handler!

Is that column is your last column?? Check the record delimiter!

Set APT_DISABLE_COMBINATION to true and try to figure out which stage is causing error

I don't see how having them in different database makes it an ETL requirement. If the result will be presented in a report, it is still a reporting requirement. You can use dblinks in Database l ... Need to query it and load it to DW table.. To make the situation simple and understandable , i didno...

ray.wurlod wrote:You don't need DataStage to do that. It's straightforward DML.

DataStage is an ETL tool, not a reporting tool!
...

The tables are from different database!!