DSXchange

Hi Patricia, build both lookups and then try to write, in the output field derivation, something like that: IF lookup1.NOTFOUND THEN lookup2.field ELSE lookup1.field Hope this will help you Riccardo ----- Original Message ----- From: "Desiano, Patricia" To: "datastage-users-list" Sent: Thursday, May...

Guys, Ive got a couple of source files that I want to concatenate together (i.e. append one to the bottom of the other) and process them as one. Ive tried doing this by loading them into a Hashed File but the key fields are not next to each other or at the top, so to over come this I rearrange them ...

Can Data Stage handle Conditional Hash Lookups all in ONE TRANSFORM JOB...? Where... If the result of HASH File Lookup #1 is NOTFOUND, Go to use HASH File Lookup#2 to get the next Oracle seq nbr and pass it to output file. Goal is to have all records populated on output of transform with a valid seq...

What are all the disadvantages of using HASHED files.

Tks

Kasia, I believe you are referring to an ETL methodology document I mailed out to anyone who wanted it. This methodology is an informal document I wrote describing an architecture for a uniform design and best practices for building an ETL application. This document later became part of the framewor...

Yes, thats another good idea. Anyway, about performance, if I have to load something like 50000-300000 lines, will I have a real time difference between Iconv, Ereplace or Substrings transformations? Kasia At 09:36 16/05/2002, you wrote: >Hi Kasia, >if you know the input format (I think YYYY/MM/DD) ...

Hi Kasia, if you know the input format (I think YYYY/MM/DD) You can also process input date as following: 1. Your input_date is: 2002/05/16 2. You can use this sintax into derivation: input_date[1,4]:"-":input_date[6,2]:"-":input_date[9,2] (your date become 2002-05-16) 3. Built a "User defined SQL" ...

Someone have send a very useful ETL methodology documentation a few months ago. In this document Batch_number and/or Process_name columns are prefered to a last_update_date information to tracing ETL refresh cycles. I would appreciate more information or examples from your designs. If really appropr...

Wow, I have it in my version. Thanks for the tip! Kasia >Depending on your version of DataStage you should be able to see how >the generated SQL is changed to reflect the change in datatype. >(although you might only see this in sources). For example, a column >marked as timestamp will appear as: > ...

I while ago, I ran some experiments with using a DATE type in DataStage when reading and writing through the ORAOCI8 stage. My conclusion was that there were issues in handling the century part of the year resulting in it being unreliable. My recommendation is to not even try using a DATE data type ...

Oracle columns with a DATE type are interpreted by DataStage as follows. When the column is set to timestamp (default when importing table definition) in the Oracle stage the only format accepted is YYYY-MM-DD HH24:MI:SS. If you change the column to varchar in the Oracle stage then DD-MON-YYYY becom...

hi, You should choose the sql type as varchar in the seq file stage and then in the transformer stage use ICONV to convert the sting into an internal date format. The sql type in the OCI stage should remain to be date. Probably the syntax is ICONV(input string,"D/YMD[4,2,2]"). This should be availab...

Hi Charles, Ray is right about the class material. Is there any way I can help you out with? Please let me know. Pavan Marpaka Datawarehouse Trainer Education Services Ascential Software Corp. Pavan.Marpaka@AscentialSoftware.com -----Original Message----- From: Raymond Wurlod To: Ghobrial, Charles C...

I am afraid I can not email the "Programming with DataStage BASIC" class to anyone. The main reason is that this is an instructor-led class owned and offered by Ascential Software (and, as you can see below, I am not employed by Ascential Software). The other possibility is that youre requesting the...

I load a seq file to an OCI8 stage through a transformer. I have columns containing dates with format YYYY/MM/DD and I load them in an Oracle table in a date datatype column. Which SQLtype choose in the seq file stage? Date or Timestamp? And in the OCI stage? The Date format doesnt work and I dont w...