DSXchange

Hi, I'm supposed to create a job, which is kind of rollup operation. But while doing so I need to lookup some data from the other table which has been there in the target . and I'm not very sure about the volume of the data to be looked up. So my question is , what's the best way to do this? shd I w...

Thanks a lot for this valuable information. But now I'm very curious to know why ppl say that if u r working on datastage u shd have a very sound knowledge of UNIX. If say I'm going to use job sequencer for my scheduling of job then i guess UNIX will not come into picture at all. Please correct me i...

Thanks for ur help guys..
T

dsxuserrio wrote:If you are learning UNIX and Datastage at the same time , dont mix them in your learning phase.

Hi, I'm learning UNIX shell scripting .. so I'm wondering typically what kind of shell scripts are requires in PX. I guess as per the requirement it might differ but I'm trying to find out the typical examples so that I can practise on it. Please can anybody shed light on this . It will be really he...

Thanks guys for the valuable feedback. But now the question what class shd I attend , I want to take online class ..
Also I visited the ValueCap site but there they haven't mentioned about the PX course. Do they conduct it on regular basis?
Please let me know.

Hi, I'm planning to take "DS314PX" online course. I'm wondering has anybody already taken it? From site I found out it's $500 but I couldn't get the details like what's the duration? How helpful it is?Do they provide any hard copy of study material? Samples? What it consists of? Please let...

well I just asked this question because I really wanted to know about it..no sales related information was expected. I posted it because I saw couple of posts related to 7.5 version & thought somebody can shed light on it.... Don't take it otherwise. Thanks, Bilwakunj Editor's note What is in ea...

Hi,
Before exporting the job/project how to determine is anybody else is connected to it or not? Is it done through the UNIX command or datastage has that routine/Macro for it?

Thanks in advance!!

Thanks ArndW for ur reply but the thing is I don't have that version.. I know some folks are using it so I'm just curious to know what's new in 7.5. Thanks, Bilwakunj Hello Bilwakunj, on your client PC go to Start -> Programs -> Ascential DataStage -> Online Manuals -> DataStage Documentation and in...

Hi,
I want to know what's the new features are available in 7.5 version as compared to 7.0. And what kind of bugs have been fixed in 7.5 which are present in 7.0.

Thanks,
bilwakunj

Hi,
I'm aware of datastage 6.0 and curious about Datastage TX. What's the prerequiest for learning TX, and how is the market in us as far as TX is concerned?And also what's the best way of learning of it?
Looking forward for your valuable guidence.


Thanks,
bilwakunj

Thanks ray.I will try both methods If it's already in the hashed file, it's a duplicate. Keep writing to the hashed file, so that later duplicates will be detected. To capture only the duplicates, test whether it was found. For example Not(RefInputLink.KeyCol.NOTFOUND) or Not(IsNull(RefInputLink.Key...

Hi, I am creating a job to find the duplicate values. Source is seq file & target is also seq file. The job uses hash file to determine the duplicate value. If there is duplicate record it is written to the target seq file else a new record is added in the hash file. Total there r 2 hash files. ...

Hi, I am new to datastage and know that datastage is an ETL tool. I am trying to relate my therotical knowledge to practical knowledge. I want to know how things are done in reality. I am curious to know in industry, how data is moved from source system to staging area? Where and How exactly datasta...

Thanks a lot sonia...It's really helpful... By setting the rows per transation to zero in the tab "transaction handling", you can make sure the commit happens only at the sucessful completion of the job. In this case you need not worry about deleting records etc. But if the rows per transa...