DSXchange

It doesnt seem to be restored. Its my vpn pc and have to take back to re-install designer. Any other option ?

Text Menu is lost.
FILE ... etc.

Text Menu is lost.
FILE ... etc.

My designer menu is lost ! Please help to restore it.

Any Other suggestions ?

I want to pass through Non-Group columns (char and date type) from the Aggregator stage. I can't use join stage to combine columns back.

what conversion code i have to use for Char and Date type to pass the data from Aggregator using Max function.

Or any other suggestion ?

Use following code in .bat file. First command resets the job in any state and resetting a job takes few seconds. Then second command runs it. C:\ myserver \APPS\Ascential\DataStage\Engine\bin\dsjob -server myserver -user myuser -password mypassword -run -wait -mode RESET myproject myjob C:\myserver...

Use following code in .bat file. First command resets the job in any state and resetting a job takes few seconds. Then second command runs it. C:\ myserver \APPS\Ascential\DataStage\Engine\bin\dsjob -server myserver -user myuser -password mypassword -run -wait -mode RESET myproject myjob C:\myserver...

im extracting date field from a flat file and want to use this date as parameter to use in other jobs where i have to query other tables on this date. How can i do that. Or any other suggestion.

ray.wurlod wrote:Learn FTP.

I have read it and have questions:

a) As i read "File Transfer plug-in, extracts data from, or writes data to, a single text file".
So can i use xml files to ftp using plugin ? For xml files do i have to use folder stage as input to ftp?

I want to FTP two xml files created by datastage jobs to remote server. Never done before ftp. Any suggestions.

In my actual job i was using the Remove dup stage using A and C as key because there were duplicate rows for A and C. (to better understand see below now): A B --- --- 2 K 1 J 3 L Reference Dataset: A C --- --- 1 33 1 78 2 65 1 44 3 21 2 15 1 33 3 21 Target Dataset: (required) A B C - -- -- 1 J 33 1...

I have the following scanario and trying to get the Target dataset as below: Prmiary link: db2 stg -> remove dup stg -> Tx -> Join (L-outer) -> Target Dataset Reference Link: db2 stg -> remove dup stg -> Tx -> Join Primary Dataset has following data: A B --- --- 2 K 1 J 3 L Reference Dataset: A C --...

Ray,
Would you explain it in detail plz.
do i have to do lookup and then output to transformer to use the condition?
how would i use *** value there ?
can i use 2/3 lookups at the same time, what would be order of execution. first row would be checked for each lookup.

Hi Ray,
I want Explicit Value of *** in 2nd lookup.

Hi Josh,
I dont want to use reject anyother option ?