Search found 22 matches

by s_avneet
Fri Oct 28, 2016 6:20 am
Forum: General
Topic: Environment Variables Usage
Replies: 7
Views: 3012

Thanks a lot :)

Marked as resolved
by s_avneet
Wed Oct 26, 2016 7:40 am
Forum: General
Topic: Environment Variables Usage
Replies: 7
Views: 3012

Thanks a lot, I will go ahead with the approach. Another point I need to ask, All the incoming files will be in the Inbound folder, I will move them all to Inprocess folder. I plan to use Execute_Command for the same. Can I use a single script for all the jobs sequencers or do I need a separate scri...
by s_avneet
Mon Oct 24, 2016 10:32 am
Forum: General
Topic: Environment Variables Usage
Replies: 7
Views: 3012

Ok so as I understand, I create Environment Variables in Admin Client and create Parameter Set containing the variables, set to $PROJDEF.

One last question. From a performance perspective, will this ever be a problem? I would be sharing the same set across different jobs at the same time.
by s_avneet
Mon Oct 24, 2016 6:21 am
Forum: General
Topic: Environment Variables Usage
Replies: 7
Views: 3012

Environment Variables Usage

Hi All, I have a quick question about the usage of environment variables and Parameters. I would build around 35 jobs, performing the same functionality of moving files from one location to other with a minimal of transformation. Now the directories would remain common across all the jobs ( say inbo...
by s_avneet
Sat Sep 17, 2016 3:02 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Composite columns should be Unique
Replies: 5
Views: 1861

Not Informatica, I come from a world of ESB and DataPower :)

You are right Craig.
The major task is to check for duplicates and I am not able to get it done on composite columns.
by s_avneet
Fri Sep 16, 2016 9:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Composite columns should be Unique
Replies: 5
Views: 1861

Beginner to DataStage, kind of experienced in Integration world :) :) Well, the non unique records to be captured as rejected and the job status will be returned back to the encapsulating sequence job. If job status is ok(no records rejected) the file will be moved from staging_out folder to Outboun...
by s_avneet
Fri Sep 16, 2016 7:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Composite columns should be Unique
Replies: 5
Views: 1861

Composite columns should be Unique

Hello All New to the DataStage world, I have the following requirement. Creating a parallel job: Seqfile1 > Transform > Seqfile2. Incoming file like: col1,col2,col3,col4,col5 Need to check that if col1:col2:col3 concatenated form a unique combinations. Is it possible to handle in the transform stage...