DSXchange

You can use command line functions like orchestrate with dump option to convert dataset to sequential file.
Fileset can be concatinated together based on the control file.
Not sure, how RCP helped you to save files.

Okey.... Key for the each table (Backup for two consecutive days) should be marked as Key in Chane Capture and Preferred field can be marked as data or optionally All fields can be marked as Data field in Chagne capture. But capturing changes based on Database log should be more faster. Not sure, wh...

Good to see the answers for the posts.
If Pavan, looks into this, hope the topic will be closed.

What are the key fields?
It should be Ac_N,Serv_N,Period_K and not Called_Num included in it.

One of the other streams is holding the same field name as "Packs_Per_Carton"

Are you expecting 20061231 or 20061131?
Because, Nov has only 30 as the final date.

Hi Nirav,

What is the logic on which the Change is captured?
Is it compared with Production database (Target databse)?

All this reminds be a famous quote of Bill Gate said on 1981
640K ought to be enough for anybody.

The optimized approach would be...
wrap the SQLs in a SQL file. Call that SQL through a shell script. Call that script through an Execute command Activity stage in Datastage. Call that JobControl using a BASIC Routine.
And finally Schedule it.

Perhaps me too.

What is you version of datastage? ChangeCapture should be able to find the difference in the Input1 to the Input2. A flag used to indentify this change. Full Outer Join coupled with Transformer with Null Detection can be used to construct the similar functionality. If you have any timestamp field to...

Doloane wrote:.....because I am a naughty SPAMBOT.

I wish Doloane should loging and look for this

Great work DSGuru2B!!!!!
Keep going.... You should be easily passing the list above you.

Have you tried to stop the dbx before trying to kill it. dbx Help Manual

So I assume its LDM to PDM (Logical Data model to Physical Data Model).

Check if DATE.TAG(DateGenericToInternal(l_Modified_I002.SI_CURR_END_DT)+1) this gives you the Date part alone. Say 2002-04-06.