DSXchange

Hi, I am designing a simple job that uses a sequential file as source and target along with a transformation stage. when I changed the metadata of the source stage, I lost the transformation coding done in transformation stage. Whenever I do a change in the metadata and reloads the metadata in seque...

In transformation stage put a constraint as follows If you have multiple columns, you need to concatinate them to get a single record.

All the best

Girish Oak

Hey, you can also do this YEAR.TAG is an in-built transformation.

-- Girish Oak

Hi Bapajju, Here is the solution, please try and let me know. In a single job use use sequential file twise. Sort data from one file in ascending while the other in descending order. Take top 10 records from each sort stage and merge them to get the final list. If this doesnt work, as I doubtful abo...

Hi Tim, I also have faced similar kind of problem. I had a hash file consisting 3 columns with first column as Key column. I populated the hash file from a table. When I used the same hash file with the same data but different key column (say 2 or 3 column). The data got swapped automatically. The r...

Thanks Kenneth, I have also thought something similar but I am not very sure whether this can be done ot not. My idea is as follows I will use a hash file that contains zip code, city and state (Country is not required as there is only one country) I will concetenate the line 1,2 and 3 to get 12345 ...

Hi, I am sorry guys :oops: for misguiding (not intentionally). All the data belongs to only one country and not many. while hiding the original data, I need to change some names here and there, while doing that I mis-out a couple of records to change, that caused some mis-undestanding. By the code g...

I have following type of data D0100028||34 ROAD TELAWI|BANGSAR BARU|MUMBAI||| D0100029||221-1&2 RD PERKASA SATU|GAON MALURI|OFF RD CHERAS MUMBAI||| D0100031||42 ROAD SS 22/34|GAON MALURI|OFF RD CHERAS MUMBAI||| D0400001||P O BOX 141|GAON MALURI|OFF RD CHERAS MUMBAI||| D0400005||BONG CHIN TERRACE...

hi,

Want to know some basics
What is Quality Stage?
What is the use of Quality Stage?
Doest it come along with Datastage or need to buy seperately?
How it is related to Datastage?

Thanks in advance

Girish Oak

I have hash files for zip code, city, state and country. So what I am thinking is to use this has files for lookup by which I can identify which zip code, city, state etc. But I dont know whether it can be implemented or not. Also not sure whether this could be the right solution or not Or any othe...

Dear Ken,
I too need a copy of code. Please make available online ASAP. Seems very cool

Thanks in advance

Girish Oak

Hi, I have some different kind of requirement probably anyone of you, may or may not have face this. My requirement is as follows. I have a record that has three columns for address say addressline1,2 and 3. Any of these line1,2,3 may contain zip code city state and country value. Unfortunately thes...

Thanks to all for your comments. :D

Girish Oak

hi, while roaming around this forum, I found many basic codes written or suggested for different different purpose. Which confused me a bit by the question whether GUI provided by Datastage is useful or not? :? Also Could anybody give me a case where we can not use GUI and we have to use Basic codin...

Hi, I have number of data files. Each file has first five rows that defines some values seperated by comma. Nothing to do with these rows. Similarly, it contains a couple of rows at the end of file. Each file size is around 2MB. I in between there is data which is seperated by comma. The first colum...