Hi Ernie,
Got it! I mapped the "anon choice" to the link name and then all the columns attached to it were mappable.
Cheers,
Bob.
Search found 136 matches
- Wed Apr 24, 2019 8:25 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Json parsing multiple layers
- Replies: 5
- Views: 5252
- Wed Apr 24, 2019 7:28 pm
- Forum: Site/Forum
- Topic: Premium Membership
- Replies: 2
- Views: 12904
- Sun Apr 14, 2019 8:55 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Json parsing multiple layers
- Replies: 5
- Views: 5252
- Sun Apr 14, 2019 8:30 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Json parsing multiple layers
- Replies: 5
- Views: 5252
Json parsing multiple layers
Hello, I wonder if anyone can shed any light on this JSON parsing problem. The following file structure is handled fine by the Hierarchical stage: [ { "reach": "national", "profile_id": "5y2", "First_name": "Bob", "last_name": &qu...
- Sun Feb 10, 2019 11:09 pm
- Forum:
- Topic: Same as Database Schemas not working
- Replies: 0
- Views: 3409
Same as Database Schemas not working
I am hoping that someone has successfully deployed the above option in IGC Data Lineage Management. Using this option should achieve two things, as I understand it: 1. Display the correct icon for an oracle table in the Data Lineage display 2. Allow Data Lineage from the table perspective Neither of...
- Mon Feb 05, 2018 6:41 am
- Forum: Information Analyzer (formerly ProfileStage)
- Topic: Executing the IA rules outside the information analyzer
- Replies: 1
- Views: 11779
Hi Neeraj,
You exceute virtually all the IA commands from a script (called by DS, if you wish) using the API. This link explins the API:
https://www.ibm.com/support/knowledgece ... intro.html
Hope that helps,
Bob.
You exceute virtually all the IA commands from a script (called by DS, if you wish) using the API. This link explins the API:
https://www.ibm.com/support/knowledgece ... intro.html
Hope that helps,
Bob.
- Wed Jan 31, 2018 3:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Data Copy Issue
- Replies: 11
- Views: 5919
- Tue Jan 30, 2018 5:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Data Copy Issue
- Replies: 11
- Views: 5919
Hi there, This might be a slightly hieretical post but if all you are doing is copying data from one DB2 table to another on the same DB2 server with a where clause, have you considered using cursors? You can call a script from a DataSatge job, which starts a DB2 command line session which uses SQL ...
- Fri Jan 26, 2018 5:17 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: IBM Is going to discontinue DataStage server Edition?
- Replies: 12
- Views: 24936
I know of one site which has a single node parallel licence. So perhaps IBM, with saying anything publically, are trying to sell only parallel licences to new clients even if it's a single node. I agree though, I don't believe that the server edition is going away especially as sequences are server ...
- Thu Jan 18, 2018 7:50 am
- Forum: Information Analyzer (formerly ProfileStage)
- Topic: Any way to export rules to Excel?
- Replies: 7
- Views: 17204
You can use the api to extract almost anything from IA including the data rules and data rule definitions to xml and in some cases csv as well. Here's the link: https://www.ibm.com/support/knowledgecenter/en/SSZJPZ_11.3.0/com.ibm.swg.im.iis.ia.restapi.doc/topics/r_restapi_getlist_commands.html Hope ...
- Thu Jan 04, 2018 10:14 am
- Forum: General
- Topic: Select rows from table and use results as parameter to job
- Replies: 6
- Views: 5233
If I understand correctly you want to run a job once per employee/date combination and pass the results on to the next process. I don't know if that will be quicker as you hope, but here's how I have done this sort of thing in the past: Output the list of employess to a flat file. Turn the flat file...
- Thu Nov 30, 2017 5:03 am
- Forum: Information Analyzer (formerly ProfileStage)
- Topic: Import rule definition using API loses description
- Replies: 3
- Views: 13572
- Wed Nov 29, 2017 10:38 am
- Forum: General
- Topic: Slow DataStage performance
- Replies: 15
- Views: 10120
- Wed Nov 29, 2017 9:03 am
- Forum: Information Analyzer (formerly ProfileStage)
- Topic: Import rule definition using API loses description
- Replies: 3
- Views: 13572
- Wed Nov 29, 2017 9:01 am
- Forum: Information Analyzer (formerly ProfileStage)
- Topic: Import rule definition using API loses description
- Replies: 3
- Views: 13572
Import rule definition using API loses description
I wonder if anyone can help me with some apparently inconsistent behaviour when importing a data rule definition using the api? Here's the api command I'm using: CreateCmd=`$IAAdminPath/IAAdmin.sh -v -user $user -password $password -url $url -create -projectContent $InputFolder/$ruleName -projectNam...