DSXchange

Hi,
Can anybody tell the importance of the $ character and where we use it and how we use it.?

chulett wrote: Or via hand-crafted job control. Or...

i know the options mentioned can you please tell me what is hand-crafted job control

chulett wrote

By scripting does it mean to write shell script that can be be used in the filter command or to do separately outside

Hi all I want to zip the file and pass it to the remote server can i use a seqentail stage to zip the file and then use ftp stage to pass it to the remote server. In the stage properties of the sequential file i have given in the stage uses named pipes and in the inputs i gave "zip ptest ptest....

thanks this is a server job

Hi all, I have a sceneraio like this I store the fileNamesand the count of the records in a variable which is used in the datastage rountine I have doubt whether is there any limit on the length of the variable If i count all the files they come around 30 and each file name is 20 characters long so ...

Hi all, I have requirement as follows In datastage I need to pass the creationdate as a parameter to the nameof the file. the parameter is #ROOT#/DD_SAP_#DSJobStartTimestamp#_1.CSV AFTER the job is run the name of file would like this DD_SAP_2006-10-17 11:12:10_1.CSV IN UNIX SERVER But I want to hav...

Hi I have a requriment like this i have job which generates a five .csv extension files. Once the files are generated i have to create a file such that each row in the file should contain the file name and the noof records in that file and the next row the other file nameand records of that file.. T...

i want to create job in the designer such that when i run the job a dummy hashed file should be ceated can i do like this.. transformer------>hashed file i don't want any column names, just pathand the file name.. i have a doubt what should be spcified as input column in the transformer stage when i...

what are stages needed to create a dummy hashed file

Mike,
Thanks for your valuable suggestion... i am trying with out the sequential file

with out using the look up hashed file can we do anything in the transformer for inserting or updating the reords target table

the sequential file was a part of mine design process.... the whole idea behind that was the sequential file stage has to wait until it recieves all the records from the oracle stage and then it performs look up with hashed file where this hashed file takes records ffrom the oracle stage target with...

Hi all, I have a design as follows oraclestage--->sequentialfile--->transformer---> output oracle stage output oracle stage has two links one for update and insert hashed file look up.... with only surroagate key column what I have to do here is that I have to insert or update i have done the follow...

Hi all I have a following a requirment like this... I have dsx file of particular job as an input file like this.... This is just a part of the dsx file BEGIN DSSUBRECORD Name "sNo" SqlType "4" Precision "10" Scale "0" Nullable "0" KeyPosition "...

thanks a lot to everyone and to their valuable ideas.... I tried with all the options...