DSXchange

Hi, My Source is a XML file backed up by a XML Schema.One of the element types defined in XML schema is xs:anyType.I came to know that Tx does not support anyType. My question is is there a clean way of Handling xs:anyType ? Sample schema definition for reference <xs:element name="TestType"...

Hi, Iam looking for best practices to enforce business rules or content validation rules.These rules are to make sure data is valid and confirming to business standards.Typically where these rules are enforced ? on Input Cards or on Output Cards ? or some other place . Any suggestions/advices apprec...

Getting foreign keys can be an interesting exercise. It's not a problem for existing data but when you are creating all new data, you've got to know when this is committed to the database. So if you create a parent row, unless you commit it imediately, you can't get the foreign key for a child row ...

I think I stepped into this with good intentions, but think I am out of my really small arena of expertise. Brings back the saying of when you find yourself in a hole, stop digging. I surrender the floor to those more experienced in Jack's issue. :oops: Atlast i was able to get it resolved. First o...

With DSTX, it is possible to produce a cartesian product just as in SQL when you do a select and join two tables incorrectly producing large number of rows returned. I guess I don't understand fully what you are trying to produce. Plus, I have not used the DB interfaces as my situation has not allo...

That worked!!. i just changed the series object from DBTable to ROW(s).
Thanks alot guys.
Special Thanks to John for your help.

To iterate your series objects to correctly call a functional map, you need to use your input series object on an output card's series object. I hope this helps, John I generated a type DBTable --> which has Row(s) e.g., LINTEITEM-->DBTable --->Row(s) --->Column names My Output card is mapped to DB...

janhess wrote:What do you plan to do with the table name in LINEITEM?

When i generated the type tree from DB Interface Designer thats how it was generated.It created tree as

Data --> TableName--Column
Row
DBTable

Iam not sure about whether my OutputCard is series or not ? when you a series object do you mean multiple occurrances ? Since my target is Database my output card is referring to a type called LineItemDetails --->which has Row LINEITEM (S) where LINEITEM is my table name. LineItemDetails ---> Row LI...

I have a functional map which should be creating one output record for each occurance of input record.According to the map designer interface guide ,we just need to pass the input type that occures multiple times as argument to functional map and rest will be taken care by Tx. Structure of my input ...

Thanks it worked!!!.But iam still not sure how this works in one to many scenarios.In otherwords suppose relationship between Table A and Table B is one to many and if my source have two rows of A and 5 rows each of B.I am not sure how tx is going to populate appropriate FK.I created my OutputCards ...

From a given output card you can not only reference any of the input card, but also any of the preceeding output cards. So in the output card for B's FK reference to A, use the key value from the output card for A. John Thanks for the reply. Iam new to this product i tried to drag the values from O...

You can only update one table per output card. Thanks for the reply.If thats the case how can i pass Foreign Keys to other tables.Let me be more specfic suppose if i have three seperate cards for table A,Table B and Table C. Once data is inserted in table i need to pass the foreign key reference to...

Hi, I was trying to create an OutputCard that can set data across multiple tables.Here is my scenario My source is file My Target is Oracle Database.Database structure is A- No dependencies B- Has FK reference to A C- Has FK referebce to B I created a type which composes of A --B --C. Now my questio...

Atlast it worked !!!
for some reason
TEXTTONUMBER(DBQUERY(XXX)) is evaluating to NONE

when i changed it to
LEAVENUM( DBQUERY("SELECT TEST_SEQ.NEXTVAL FROM dual","C:\Ascential\test.mdq","test"))

it worked.Thanks guys for your help in resloving this.