DSXchange

Fellows,
I still don't have a to the point reply over here. May be more details be inside 'Premium content' but since am not a member and don't see it becoming in next few months, so, from tehre too am not able to see the response...



Regards,

Hi Chullett, you are right 'ADS' is for Ascential Data Stage and also you are right in mentioning that its no more Ascential. My question was specific to Server Edition as it is what currently I have available with us. But, same question stands valid for Enterprise Edition/PX. What I am interested t...

Hi,

I need to know about use of ADS as ETL tool for telecom sector DWH. What forced me to ask this question specific to telecom dwh is the huge data size and very tight data warehouse ETL Time Window.

Please, share your experience...

Thanks and Regards,

Hi, sorry for mentioning 26 columns its acutally 32 and yes it not a fixed column instead its a '|' separated 32 columns file. I verified the metadata, it exactly matches the column definition for the data file. But, I did found the source of this error, while browsing the actual data, I recalled th...

Hi, refferint to last thread details; I made sure that I used same file to import meta data definition into table definitions; then I used same file as source for the sequential file. If the issue was with metadata, I wonder why ADS is displaying me only one record from the file after giving the err...

Hi, Thank you for the valueable inputs. This time I made it more simple by just dropping a sequential file stage and linking it to a transformer stage. I imported the table definition from the same source file which contains the actual data. it imported the definition perfectly, and showed the data ...

:-) Well, thats one of the files that I have to load daily to our Data Warehouse staging area. Yes I tried to view the data; it first gives a warning and then shows only the first row of the data. Job design is pretty simple; I used sequential file stage and transsfomer stage to write the same data ...

Hi All,
I tried to transform a sequential file of sizze 544 MB into another sequential file with different delimiter character; but the transformation returns after transforming only first row of the data file; can you please guide as what could be reason for it?

Regards,
Shahid.

Hi, Thank you for the response. Actually, while asking this question I have in mind the delta size of a source table(s). For example one source one day call detail records are of approx. 35 GB per day and if i load and transform it using ADS stages, what ETL time performance impact it will have as c...

Hi,
Can Any one who have done ETL through scripting and latter on moved to ADS give his experiened response?

Regards,

Hi Gurus, I have just started using ADS for ETL, before I used to do all the ETL scripting in SQL/PLSQL, Shell scripting etc. I have a pipe separated ascii file of about 546 MB that needs to be ETLed to our data warehouse for recharges subject area. There are two approaches to it 1. write a custom s...

Hi Kumar, Thank you for the guidance; It worked! I did create a hashed file; used it to lookup country name based on country-code and wrote results to target odbc table. While working on this I oberved following: 1. When I created a hashed file; it resulted in creation of a directory which contained...

Hi, Here i list steps that I have taken to create a server job that uses hashed files, but is not working properly. 1. I dropped an ODBC-stage and cofigured it to get data from sql-server database table authors. 2. Linked it to a transformer which is actually to do a lookup of author contry code and...

Hi Kumar, Thank you for the response; but my question is what steps do I need to take to convert/make a text file to hashed file; and then using it as a source for doing lookups? Thanks, Shahid. You need to create the hash file for populating it with data. Once the hash file is created you can use t...

Hi Gurus, This may sound very basic one to you; but as it is said a thousand miles journey starts with a single leap, so is case with me: By now, I know what hashed files are; for what purpose we use these. But, I need to know, 1.How do we populate these hashed files first time, for example If i hav...