Hi All
Sorry for coming back again! The solution was working fine if we have one primary key. But we have some tables with composite key. In that case how can I pass multiple keys to Difference stage ?
Please advice.
Thank you all
Search found 71 matches
- Thu Jan 05, 2012 2:32 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Comparing two tables with same metadata
- Replies: 8
- Views: 5428
- Tue Jan 03, 2012 11:50 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Comparing two tables with same metadata
- Replies: 8
- Views: 5428
- Wed Dec 28, 2011 11:41 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Comparing two tables with same metadata
- Replies: 8
- Views: 5428
- Wed Dec 28, 2011 4:37 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Comparing two tables with same metadata
- Replies: 8
- Views: 5428
Comparing two tables with same metadata
Hi Everyone We are trying to compare two tables with same structure from different schemas. We have about 300 tables in both schemas. Instead of developing separate jobs, we want to build a single common job with run time column propagation on and loop the table names through the sequencer. I have b...
- Fri Feb 06, 2009 3:52 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Delete messages from MQ Queue
- Replies: 2
- Views: 5249
it takes advantage of having multiple links coming from a Transformer, and wrapping those into a single transaction I was actually going through that in HELP files and I am not sure how to implement that Units Of Work logic. Let me check couple of sample jobs and see if I can get it working. Thanks...
- Fri Feb 06, 2009 11:43 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Delete messages from MQ Queue
- Replies: 2
- Views: 5249
Delete messages from MQ Queue
Hi, We are trying to get used to processing messages to/from MQ using WebSphere MQSeries Stage in 7.5 server environment. We are using Destructive read with commit/backout at the end options to make sure we are only deleting messages after everything is processed successfully. Our jobs design involv...
- Fri May 09, 2008 10:45 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: dsjob or client instal on UNIX machine
- Replies: 11
- Views: 6084
- Thu May 08, 2008 12:53 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: dsjob or client instal on UNIX machine
- Replies: 11
- Views: 6084
- Thu May 08, 2008 11:04 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: dsjob or client instal on UNIX machine
- Replies: 11
- Views: 6084
- Thu May 08, 2008 10:45 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: dsjob or client instal on UNIX machine
- Replies: 11
- Views: 6084
dsjob or client instal on UNIX machine
I was wondering if we can install datastage client or atleast the ds command line interface on a unix machine. From the documentation it looks like complete client can only be installed on Windows machines .. But just wanted to make sure that. Our requirement is we have some java scripts on unix-A m...
- Thu May 01, 2008 3:05 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DataStage Job Sequence LOOP aborts after 256 iterations.
- Replies: 4
- Views: 6452
- Wed Mar 26, 2008 12:36 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: CLEAR.FILE RT_LOG while job still running
- Replies: 1
- Views: 2240
CLEAR.FILE RT_LOG while job still running
We have a job that is in running state for long time even though it is not processing anything. We have identified the reason as log file becoming huge (more than 2.5gb!!) and it started giving "... computed blink do not match .." error while trying to access director logs. After identifyi...
- Thu Oct 12, 2006 11:35 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Generate Column value
- Replies: 12
- Views: 4995
>>The column b need not be generated Above logic will not generate B .. you can TRY this: stage variables: sv_2old, sv_counter, sv_d, sv_2new in same order sv_2old = sv_2new sv_counter = update if sv_2old and sv_2new are different. sv_d = derive depending upon requirement (first char from B and sv_c...
- Thu Oct 12, 2006 11:13 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Problem while Bulk insertion of records
- Replies: 14
- Views: 6100
Hi Prasad, You are right on your point.The problem was very much what you stated.I was able to test the same with the inputs that you gave.Thanx a lot for the valuable help that you have provided. Thanks alot. Good!! If you still want the update happen when c2 matches .. you can update the where cl...
- Thu Oct 12, 2006 11:09 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Generate Column value
- Replies: 12
- Views: 4995
what is the data type of B?? is the length of B alwase fixed?? anyway this is what I would do .. stage variables: sv_1, sv_2, sv_3 sv_1 (counter) if not initialized yet initialize sv_1 else compare with sv_2 if they are different update counter else have same value sv_2 = B sv_3= first char of B : s...