DSXchange

Hi, I was wondering if there is a way to do this.I would like to know if I have three Hash Files each having a single column say Col1. Hash1 Col1 is Source to transformer stage Hash2 Col1 is lookup to transformer stage Hash3 Col1 is lookup to transformer stage. I can do a lookup Hash1 Col1 with Hash...

Hi, I was wondering if there is a way to do this.I would like to know if I have three Hash Files each having a single column say Col1. Hash1 Col1 is Source to transformer stage Hash2 Col1 is lookup to transformer stage Hash3 Col1 is lookup to transformer stage. I can do a lookup Hash1 Col1 with Hash...

Hi, I was wondering if there is a way to do this.I would like to know if I have three Hash Files each having a single column say Col1. Hash1 Col1 is Source to transformer stage Hash2 Col1 is lookup to transformer stage Hash3 Col1 is lookup to transformer stage. I can do a lookup Hash1 Col1 with Hash...

Hi, I would like to know how to configure oraoci9 stage in server 7.5 for a outer join between two tables. Table A --------- last name first name ssn Table B ---------- ssn suffix middle initial I would like to join on ssn. Thanx in advance.

Hi, I would like a counter to be loaded in a field. For ex:- First run Record1 counter=1 Record2 counter=2 so on Second run Record1 counter=1 Record2 counter=2 so on Every time job is run counter should be intialized to 1. I used KeyMgtGetNextValue function but its not intializing counter to 1 at th...

Hi, I am working on CDC process to capture new,modified,unchanged and delete records.I was wondering if there is any difference between performing CDC process i.e capturing new,modified,unchanged and delete records before loading the data into table ,and after loading the data into table and perform...

Hi,
How to configure FTP Stage to transfer file form unix box to a shared drive(for example T:\).
thanx.

Hi,
I would like to know how to import job parameter's or environmnet variables from
one project to another.
Thanx.

Hi ,
I would like to know how to convert a .xls excel work book containing two sheets to a .csv file using dataStage because the process has to be automated.
thanx.

Hi Ray,
I would also like to include datatype and length too.Is there any way to do it.So that
I am importing the complete metadata with datatype and length.
Thanx.

Hi,
I have .xls excel sheet and I WOULD like it to be converted to .csv file.Is there any way to do it.
thanx.

Hi ray, I don't have data for the sequential file but i have metadata for the sequential file and i would like to import metadata by creating a file layout.I have 20 fields like field1 varchar2 30 field2 varchar2 40 field3 varchar2 12 field4............ can you suggest a way to create file layout po...

Kris
If the name is:Michael A C
Then first name will be Michael
Middle initials will be A C
if the name is :Leslie Marc
Then first name will be Leslie
Middle initials will be M.
Thanx

Hi, Can somebody provide me code to seperate first name and middle initial. Currently they are in the same field.Some examples are as follows Cari A Michael A C Leslie Marc Kuan-Yu Cielo Patricia Renee (Johnson) M Gary D Sr It should be like first name:cari middle initial:A First name:cielo middle i...

Hi,
Can some body tell me how to create metadata for a given sequential
file.Possibly send some sample metadata for a standard sequential file.
Thanx in advance