Search found 96 matches

by vamsi_4a6
Wed Jul 29, 2015 11:59 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: First and last record
Replies: 7
Views: 3933

First and last record

I have to fetch last record from a file but i do not want to execute the stage in sequential mode.i want to execute stage in parallel mode only. Current logic i am following. sequentialfile-->tail stage or sequentail file-->transformer stage(lastrow function as constraint). both tail stage and trans...
by vamsi_4a6
Thu Jul 23, 2015 1:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Inserting records based on gaps
Replies: 1
Views: 2085

Inserting records based on gaps

if there is any gap i have to create one extra record in output with price as previous one and output is mentioned as below.For understanding purpose i gave one product but we have so many products source and target is sequential input Prd prc effecdate enddate 1 10 1-jan-2010 1-mar-2010 1 15 1-jun-...
by vamsi_4a6
Thu Jul 23, 2015 12:52 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Design Scenario
Replies: 10
Views: 11313

@rkashyap


what do u mean by link-num (1, 2, 3 etc).I do not see any column like link-num?
by vamsi_4a6
Thu Jun 25, 2015 9:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: selecting one record out of 2 records
Replies: 16
Views: 12149

I stuckup with how to compare two records within a group ans selecting one record out of it.
by vamsi_4a6
Thu Jun 25, 2015 5:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: selecting one record out of 2 records
Replies: 16
Views: 12149

I have concatenated as mentioned below Start,End,Start_End,End_Start,Distance Bangalore,Mumbai,BangaloreMumbai,MumbaiBangalore,1500 Hyderabad,Delhi,HyderabadDelhi,DelhiHyderabad,2000 Delhi,Hyderabad,DelhiHyderabad,HyderabadDelhi,2000 Mumbai,Bangalore,MumbaiBangalore,BangaloreMumbai,1500 How to use a...
by vamsi_4a6
Thu Jun 25, 2015 8:53 am
Forum: General
Topic: Datastage path and export clarification
Replies: 5
Views: 4110

Could anybody please reply on it Could somebody learn a little patience please? You waited what - not even two hours - before deciding you needed to stir the pot? And this at a time that was smack in the middle of the night for quite a number of people. Sheesh. I am really sorry for that and I will...