DSXchange

Kirtikumar wrote:Is this error frequent?

Search the forum for link collector and you will find many posts on this topic.

No

[quote="ShaneMuir"]Am I missing something here? What sort of file? Sequential? Hash?[/quote The Problem is as follws. Hi Murali, I have one issue in Data stage 6-Unix .Could you explain why it happens. The problem is as follows: Here taking input from Informix then pass to a link practitio...

Please explain How temporory files are handled in DS6-UNIX ?

I have a problem with the link collector stage as follows. First came a warning message as above Message: PQR..Container2.TransText.LC1_2: ds_ipcopen() - Error in open(/tmp/XXXX.PQR..Container2.TransText-Link_Collector_1) - No such file or directory Then came the following fatal error message in lo...

Hi,

Please let me know about the datastage certification including the details abt the cost ?

Could You help me in the following issue in parrelel job I have . file A contains 1 millon records file B,contains 1000 records. Oracle Table C contains 1000 records I want to select some columns from A,B and C based on a condition A.id=B.id and B.id=C.id 1.Could you suggest the best way of choosing...

Hi,

1 What is the difference between an oracle stage lookup and Flat file stage lookup in a parrel job?Plz explain

2 What is the advatage of using lookup file set as a lookup

hi

Till now i am working in DS server jobs and now i try to run a parrelel job.
then it gives a fatel error "This jobtype is not currently runnable on this platform" could u help me to solve this issue

2.If we update the the source file of lookup (eg oracle table,or asequncial file )how it will visible at the lookup dynamically? DataStage does not update your lookup table automatically. If you are using a hashed file you have pre-populated this with an image from the target table. As the job runs...

sudheepkv wrote:Could you give the use of hash files and lookups in real time senario with an example?How it effects the performance?

Thanks a lot .I am a biginner in DS it is very helpful to me.

Could explin the following

1.What is Vertual Dataset
2.Please explin the second answer?I was not able to understand

Please be more specific about what you mean by "performance". Hashed files (note, not "hash" files) are the fastest possible mechanism for performing a key-based lookup, particularly if cached in memory. Thank you all.I have some more doubts .please respond 1. in real time senar...

Could you give the use of hash files and lookups in real time senario with an example?How it effects the performance?