DSXchange

Please set the "Missing File Mode"="OK" under File Properties->Options

You can also find in DataStage " Open Quick find " option, you just enter your job name in it and enter then it will show 1 match in blue color , if you click that then the " Repository Advanced Find " window will open, there you can see the option " Last modified date "...

IF Column_Value < 0 THEN 0 ELSE Column_Value

Novak,

You just edit the source data once, edit means no need to change anything you just remove and add any one record then the values will be loaded with out any issues. This is the problem with CSV files. Yesterday we have faced the same issue.

Thanks,
Sreekanth

I am able to see the XML file but unable to save XML table definition in XML Meta Data Importer.
The save button in File tab is in Disable stage.
What is the reason for this?

Mr Devendra, This is very simple. Don't add any columns to the compare stage output page and Enable Runtime column propagation , then datastage itself will decide the column names and insert the data into your target file. Your target columns will be Result+first file columns+second file columns Dat...

Take three stage variables A,B,C
and calculate column D using the logic : D= A-B-C .

Or why can't you do the calculation directly as below
D=a+b-e-r-t-p-t-y-p-u

Hi,

I think no need to convert any thing you can directly use StringToTimestamp function.
I have used the following function it is working fine

StringToTimestamp('2011-02-02T14:05:35',"%yyyy-%mm-%dd %hh:%nn:%ss")

Thanks,
Sreekanth

Thanks a lot, your reply really helped me

I have requirement like below

Before File:

Key Non_Key
1 a
2 b
3 c

After File:

Key Non_Key
1 a
2 d
4 e

Then how many records i will get after ChangeCapture stage and what is the value of the "ChangeCode()" field ?

Process your records into two flows main flow and changed flow In changed flow use aggregator and find the count by grouping on key, your output from aggregator will be key,count then use join stage and join main flow and changed flow records based on key and return count from changed flow(from aggr...

Hi,

join File1 and File2 using joiner stage with the key cust_id and return the two columns cust_name, sales_amount .

Please let us know if it is not working

Thanks,
Sreekanth

Connect your source to Aggregator and put group by on ID and do SUM and MAX and connect these three columns(ID,sum_value,max_value) to trasformer. In Trasformer calculate DIFF using the logic ABS(max_value*2 - sum_value) , here ABS function used to get the positive value and connect three fields(id,...

As you said use the Row Number Column in the Sequential File stage. Then all your input records will be having Row_number Connect Sequential File stage to transformer and use @INROWNUM to get the total count then connect the transformer to Filter stage there you put a condition like Row_number=1 or ...

First you define the keys in the target stage based on your requirement then if your database is DB2 then use load type as UPSERT (UPDATE+INSERT), it will insert the record if it is new else it will update. If your databse is Oracle use " insert else update " approach as suggested by chule...