DSXchange

[

Hi,
I need to get a single value from a query (Select min(date) as Run_date from table)
and pass Run_date as parameter to use for a later job in the same sequencer.
how to do it in data stage in detail?


thanks in advance

[quote="vivekgadwal"][quote="Jessie"] After merge- the file should looks like Col1 col2 col3 col4, clo5, col6 Key1 key2 22 33 44 55 keya keyb 12 23 keyc keyd 45 54[/quote] Ok... Did you try the way I suggested? Did it work? Let me know.[/quote] workingn on it, I'll report to you ...

here is what I need to do. file1 Col1 col2 col3 col4 Key1 key2 22 33 Keya keyb 12 23 File 2 Col1 col2 col3 col4 Key1 key2 44 55 keyc keyd 45 54 After merge- the file should looks like Col1 col2 col3 col4, clo5, col6 Key1 key2 22 33 44 55 keya keyb 12 23 keyc keyd 45 54

I'm working on 'Merge', waht should I do after 'merge'?
the out put file from 'merge, has file1.key, file2.key
how do I join them to make it one row?

thanks

[quote="ray.wurlod"][code] HashedFile2
|
|
V
HashedFile1 ---> Transfomer ---> Target[/code] ...[/quote]

what is it?
I'm too new to Datastage,

Yes, I want to left join with hash file.

use 'transformer' to join a sequence file with 2 hash files. each of the 3 files has some rows that cannot be joined with, and I want all the row from all the 3 files. how to do it?

thanks

all,

how to do left join or left outer join in transformer?

thanks in advance

test2..Sequential_File_2.IDENT1: DSD.StageRun Active stage starting, tracemode = 0. test2..Merge_1: Stage Properties > First File Path = [/home/tttt/S_al.txt] > Second File Path = [/home/tttt/S_Med.txt] > Working Directory = [/home/tttt/S_temp] > Stage Trace Level = [1] test2..Merge_1: Error opening...

does it need extension like .txt when create sequence file?

I have 2 seq_file for the 'Merge' stage, but cannot pass validation, the error is 'Link property retrieval error' any idea?

I'm new to data stage, is there any detailed documentation? the HELP doesn' thelp much