Search found 331 matches

by vamsi.4a6
Wed Jun 11, 2014 6:45 pm
Forum: General
Topic: Metadatawork bench clarification
Replies: 3
Views: 1327

Thanks for input.during installation since it is showing Metadataworkbench even though i did not selected i believe we have licence and is there any way to check whether we have license or not.Apart from checking with admin since admin does not know about this tool
by vamsi.4a6
Wed Jun 11, 2014 6:41 pm
Forum: General
Topic: sequence log clarifacation
Replies: 5
Views: 1402

@ray Thanks for input.We have auto purge enabled and In production we want to capture how many records are processed,how many records are loaded,is there any warnings,is all activities in the sequence ran or not etc.i Think we can get above information using logs. @chullet If I wrote the logic using...
by vamsi.4a6
Wed Jun 11, 2014 12:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SCD / Change Capture Logic
Replies: 4
Views: 2239

please tell me your requirement in the form of sentences.
by vamsi.4a6
Wed Jun 11, 2014 12:09 pm
Forum: General
Topic: sequence log clarifacation
Replies: 5
Views: 1402

sequence log clarifacation

we have one sequence which consists of 10 parallel jobs.I need to capture the log for all 10 jobs+sequence from unix in a text file whenever i run the sequence. Approach:Use dssearch command to get the list of jobs and for each job get the log information using dsjob command.I am thinking is there a...
by vamsi.4a6
Wed Jun 11, 2014 12:01 pm
Forum: General
Topic: Metadatawork bench clarification
Replies: 3
Views: 1327

Metadatawork bench clarification

In our project during in stallion of datastage we ask us to install only datastage.I can see metadataworkbench,fasttrack etc during installation but we did not selected these components as per client request.Now i am proposing to my client to install metadataworkbench since it will be very useful to...
by vamsi.4a6
Wed Jun 11, 2014 11:50 am
Forum: General
Topic: Quick Find doesn't find stage names
Replies: 2
Views: 2072

I believe MetadataworkBench Tool from IBM will suit your requirement.
by vamsi.4a6
Wed Jun 11, 2014 9:21 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Merge stage clarification
Replies: 5
Views: 2605

Thanks for reply.I can understand now that it is not necessary to match all the update links. even if it matches one record from update link it will show in o/p incase of unmatchedmastermode=drop You use reject links for each Update link to capture stream rows for which no match was found clarificat...
by vamsi.4a6
Tue Jun 10, 2014 2:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: MQ Connector
Replies: 2
Views: 1414

MQ Connector

1)In our project we are using WEbsphere MQ Connector and i am analyzing that job to understand its functionality. http://publib.boulder.ibm.com/infocenter/ieduasst/imv1r0/topic/com.ibm.iea.infosphere_is/infosphere_is/8.5/DesigningJobs/MQconnector.pdf?dmuid=20120831202807180503 In the above link page...
by vamsi.4a6
Tue Jun 10, 2014 2:33 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Merge stage clarification
Replies: 5
Views: 2605

Merge stage clarification

I have merge stage with one master link and 2 two update links. Clarification1:we have two records(key=1,2) in master link and one record update1(key=1) link and two records in update2(key=1,2) link . warn on unmatched masters=True As per my understanding we do not have any value with key=2 in updat...
by vamsi.4a6
Tue May 20, 2014 9:11 am
Forum: General
Topic: package creation problem
Replies: 3
Views: 1266

@qt_ky I selected randomly.you mean to say Top down -->selecting job sequence and then selecting parallel jobs bottomup -->selecting parallel jobs and then selecting jobsequence whether my understanding is correct or not. to resolve the issue what is the best way to select the parallel jobs and job ...
by vamsi.4a6
Mon May 19, 2014 9:55 pm
Forum: General
Topic: package creation problem
Replies: 3
Views: 1266

package creation problem

We created one package for 200+ jobs using Information server manager tool.The problem is some job sequences are exported with parallel jobs and some job sequences are not exported with parallel jobs eventhough we selected selected Include all dependencies option.Not sure what could be the problem a...
by vamsi.4a6
Wed May 14, 2014 11:00 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Decimals in RCP
Replies: 12
Views: 6376

@elsont

could you please elaborate on this point.how to write this query in selection criteria?

Convert decimals to string in the select query (who ever use this job needs to remember about this limitation and make sure all decimals are converted)

I am new to RCP any input is really appreciated.
by vamsi.4a6
Wed May 14, 2014 4:52 am
Forum: General
Topic: Different Versions of same Job
Replies: 2
Views: 1440

Thanks for input.Please let me know whether is it possible in Information Server Manager and any help on how to start to resolve the problem?
by vamsi.4a6
Tue May 13, 2014 9:41 pm
Forum: General
Topic: Different Versions of same Job
Replies: 2
Views: 1440

Different Versions of same Job

Day1: I developed one sequence Job which is having 10 parallel Jobs. Day2: Changes are required for one of the parallel Job(Job2). Day3: Changes are required for one of the parallel Job(Job3).On Day3 we are using Day2 code. clarification: a)At any point of time in future how should i revert the code...
by vamsi.4a6
Sat May 03, 2014 3:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Decimal to String
Replies: 19
Views: 15349

ssnegi wrote:

Code: Select all

DecimalToString(Field(DSLink.COL,'.',1),"suppress_zero"):'.':Field(DSLink.COL,'.',2)
This will remove only the leading zeros and keep the trailing zeros.
Col1 is decimal data type in the source.is field function is valid on this column?