DSXchange

Hi All, Is there a way of automating the process of Metadata Generation? My requirement would be like this : 1.If the metadata of a file is present in an excel/text/word file, Can that be read and converted into a internal Metadata format in Datastage automatically. If there is, please guide me thro...

Hi All, I need to generate a Reject Id and Reject Description for a rejected record. I have 2 files when i do a lookup some records are rejected due to key identifiers not matching. I capture that in a reject file. For ex.When i do a lookup based on a Member Id,when the unmatched records get rejecte...

Ray,

I really do not get this workaround.
Can you kindly explain me in detail.
Should I use an Exec activity to read this file?

Ray,


Where exactly do I use this @FM variable.

Is it at the field propeties do I type " @FM " ?

or in Format -> field delimiter ?

Kindly let me know about this.

Hi All, 1.When I copy it and paste it over here it doesn't show up that character. But in the text file file which is created there is a character which is at the beginning and at the end of every field. 2.I n't sure whether it is a Line teriminator. 3. When I change the delimiters to none in the Se...

Hi All, I have used an after Job routine "DSJobReport" to generate the reports. I have also got a text file with all the information on the file. But there is some junk characters in between each filed. So how do i get rid of these junk characters or how do i read this text file in an Sequ...

Hi All, The sceranio is : I have an input file with 10 records where I have an constraint in the transformer. Based on my constraints 5 records go in to the target(Taget folder) which satisifies the constraint and the remaining 5 records get in to a reject link(Reject folder). My requirement is when...

Hi Craig,

Sorry for my ignorance!

Is that in the Environment variables of the Administrator do I find the Inactivity Timeout?

If yes where in the Environment variables?
If no where in Adminsitrator?

Hi All, I have an issue on the datstage conncetivity. Issue: Iam connecting to a remote server through VPN. When I leave the job opened and idle for some 15 mins the datastage connection breaks and the job is locked. I have to release the job only through the administrator. This has a huge impact on...

Ray, I have cleaned up the resources in director,then also it runs fine for once or twice then again it just keeps on saying it is running where as Mulitload has failed. Kumar, This job is already called in an Sequencer even the sequencer keeps on runnnig waiting for the status from the job. Regards,

Sorry for posting it in the wrong forum. Kumar, I cannot go for a sequence for every job since i have almost 60 - 70 jobs. Ray, The job keeps on running it doesnt get aborted,even in the designer. From my perspective,some communication gap between the Teradata Mload and Datastage. Is that anything i...

Hi All, Issue : The Jobs keeps running even though the Mload has failed. 1.I am loading a table through a Mulitload stage in datastage 2.Due to some reasons if the Multiload fails and the Mulitload log shows an error code, the job doesnt abort it keeps on running. 3.After seeing the Mload log i have...

Thanks a lot chulett. I scheduled both ways onetime(ie.today) and every two days (ie.thursday and Friday). I was able to find the entry in AT for one time and CRONTAB for recurring schedules. So every DS UserId should have execute permissions in both utilities of Unix " AT and CRONTAB ". R...

Hi All,


The issue is resolved at last ,my userid did not have execute permissions in " AT " utility.

Datastage uses a utility called "AT" in unix server to schedule jobs,whenever it is scheduled through DS Director.


Thanks for all your inputs.


Regards,

Hi Kumar, I went through the pdf it states that, something got to do with the AT or CRONTAB command. Can you confirm whether Datastage uses CRONTAB or AT command to schedule the jobs through the Unix Server? Which is the underlying process to schedule jobs CRONTAB or AT thru unix? So that I can work...