DSXchange

You can write a small delete script in bash or something and schedule it to run via linux scheduler.

I read the contents in the link and made some progress but its just not working and I am not sure where it is going wrong. To summarize, The XSD structure is below SO_PRODUCT (Parent P1) ---->SO_PRODUCT_ATTRIBUTE (child C1) ---->PRODUCT_ASSOCIATION (child C2) --------->PRODUCT_ASSOCIATION_ATTRIBUTE ...

Actually 4 output links as "Product_Association" has another one nested called "Product_Association_Attribute" as shown in the picture. Now I have 4 output links containing the respective elements from each blue "list" icons. I apply the transformation, etc using the tr...

Not just more but way too much to learn. :) So, I imported the XSD into the library manager and here is how it looks like. http://i.imgur.com/AuHg3rR.png I have highlighted the the blue "list" icons in yellow. In the assembly editor, I have 3 steps. Input Step; XML Parser Step; Output Step...

Hello Ernie, Thank you very much for the details. The XML file in question is of 1 GB size. Hence, I am using the HierarchicalData Stage (formerly XML Stage). I have already imported the XSD as XML Table Definition like Ray suggested. Now what should I use in the assembly palette to read the data? A...

Yes, I used the above data to generate the XSD which looks like below <?xml version="1.0"?> <xs:schema id="import_data" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"> <xs:element name="i...

Hi, Being not very familiar with XML files, I am struggling a bit to achieve the following objective. It will be very helpful if someone can please direct me to right approach or design. Objective : Read a XML file, apply some transformations to its data (e.g. switch cases, change some values, etc) ...

Originally, I wanted to do an actual count of Table_A on the database, but I'm limited on time. This routine can check if any records were inserted into Table_A daily. It's no where near perfect, but will get the job done.

I added the VM A as an administrator on VM B and it worked!

Thanks.

When we run a DS job on Windows via DS Scheduler, what user ID does it use? Is it the user ID by which it was compiled last?

Say my DS job, is running on a Windows VM A and want to write a file to another VM B or to a shared drive, how do I make sure that it has appropriate permission to do so?

Hi,
I searched the forum but couldn't get any answer. Does anyone know how to round a number to nearest equal to higher tenth.

e.g.

12 --> 20
15 --> 20
1.4 --> 10

Thanks!

I could but how can it help me identify those records which were updated with type 1?

Hi, I am trying to load a Dimension table which has a mixture of Type 1 and Type 2 columns in it. The data population is working fine as expected when I use the SCD stage. But I am wondering if there is a way to populate Record_Insert_Date and Record_Update_Date in this table based on if a record is...

akshyat wrote:[[twt]] signifies the temporary work table. During run time the netezza connector stage automatically assigns values for these two tables.

If TWT is assigned at runtime then how would you give its exact name in the sql?

Thank you, Ray. I will use the state file in the jobs are see how it goes. BTW, what is your opinion about using the inbuilt DB sequence? The only options are DB2 and Oracle. Since we have DB2 for XMETA repository, I can ask for a separate database in it for generating sequence. Will it provide any ...