Search found 144 matches
- Mon Apr 13, 2015 11:29 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Update member in AttrComp member mode using MDM connector
- Replies: 0
- Views: 1943
Update member in AttrComp member mode using MDM connector
Hi, I have attributes phone number which will have multiple values stored. I need to run the job in AttrComp mode using MDM connector to upsert all the values coming from the source. However, for each value value is passed by the connector in a single interaction and only one value is getting update...
- Thu Nov 06, 2014 6:01 pm
- Forum: Infosphere Master Data Management
- Topic: restricting matches to cross source system for ind attribute
- Replies: 0
- Views: 13853
restricting matches to cross source system for ind attribute
Hi,
I am trying to match a key between 2 source systems but I do not want the key to be matched within same source system. Is there a direct method of implementing this? The version I am using is 11.0
I am trying to match a key between 2 source systems but I do not want the key to be matched within same source system. Is there a direct method of implementing this? The version I am using is 11.0
- Tue Jan 01, 2013 5:00 pm
- Forum: General
- Topic: Persistant sequence number algorithm
- Replies: 1
- Views: 2186
Persistant sequence number algorithm
Hi All, I was looking for persistent sequence number generation algorithm. meaning, when a character value is passed a corresponding number sequence needs to be generated and it should always return the same value for the same text string and different values for different characters. I could use su...
- Wed Oct 31, 2012 9:48 pm
- Forum: General
- Topic: identify list of used parameters
- Replies: 0
- Views: 1872
identify list of used parameters
Hi All, does any one know how to identify all the parameters used across multiple jobs and parameters? one way I can think of is to export the jobs in a dsx and extract the parameters using a script. but not sure how to identify the parameters that have been used within the jobs not just defined in ...
- Wed May 09, 2012 1:00 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Row leakage
- Replies: 3
- Views: 2905
- Tue May 08, 2012 9:45 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Row leakage
- Replies: 3
- Views: 2905
Row leakage
Hi, I was looking for an existing script or a job that would back track and find out which job has dropped the record. it gets bit too laborious as there are far too many jobs to be verified manually. what we have to check is the number of rows read, and the number of rows written to the output shou...
- Thu May 03, 2012 6:06 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Slow running job
- Replies: 15
- Views: 19697
Indeed, db's do have very significant roles in the performances. it could be either when reading the data or writing the data. you could check the indexes and constraints to see how it is performing with or without them. Also, you could try writing the data to a dataset and verify if that improves a...
- Wed May 02, 2012 10:59 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle connector stage is not doing index scan in update
- Replies: 2
- Views: 2713
is the table indexed on ITEM_TYPE AND ITEM_NO ? What type of index is defined? have you tried other options like merge query which will be executed completely on DB. something like this MERGE INTO LA.ITEM_T LAT USING DUAL ON ( ITEM_TYPE=:ITEM_TYPE AND ITEM_NO=:ITEM_NO ) WHEN MATCHED THEN UPDATE SET ...
- Tue May 01, 2012 5:40 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Join Fails
- Replies: 31
- Views: 15423
- Tue May 01, 2012 5:15 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Conveting Binary feed to ASCII feed in UNIX
- Replies: 10
- Views: 7213
the quickest way would be to use datastage to do this task. However, there is option like dd to convert the ebcidic file to ascii, this does not convert compressed or comp fields. so, the best way is to write a c or cobol program that converts byte by byte. alternatively, if you have perl and know h...
- Mon Apr 30, 2012 12:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Join Fails
- Replies: 31
- Views: 15423
- Sun Apr 29, 2012 11:45 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Join Fails
- Replies: 31
- Views: 15423
- Sun Apr 29, 2012 9:58 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Join Fails
- Replies: 31
- Views: 15423
Yes, James I am aware of all the 3 possibilities. strangely when I replace the join with lookup it works fine. and second thing in that environment is when I try to read the dataset from one job it reads fewer records than the dataset actually holding. and with another job it reads the right number ...
- Wed Apr 25, 2012 8:16 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Join Fails
- Replies: 31
- Views: 15423
Well, when I am running in single node config it's still producing the same results. I have verified the data byte to byte and it is matching. one more issue I could see when I am reading a dataset from the same job it reads around 4 million records only when I remove the other stages and just try t...
- Tue Apr 24, 2012 12:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Join Fails
- Replies: 31
- Views: 15423