DSXchange

Hi

I am getting compilation error when I use the SCD stage .when I try to press more option the datastage screen freezing .I checked all the fastpath options and every thing looks good but I dont know where the error is .
please help

thks
sainath

Hi
I have incoming varchar field which is more than 8000
What data type I should define in data stage and corresponding
Data type in sql server


Thks

Hi Sorry for not clear in requirements 1) if before Data set data is equal to After dataset then Record_update_date=currenttimestamp ----day 1 2) if before Data set data is equal to After dataset then Record_update_date=same timestamp as day 1 ----day 2 3) if before Data set data is not equal to Aft...

Hi
I have input data with n fields

I have requirement that if there is change in input
Data then recordupdate date = current date else recordupdatedate

What is best approach. I thought of using funnel stage and compare string in transformer. Let me know any other better approach

Thks

HI

I am using Hierarchy stage .For null data I am getting different XML output .

for some records <abc></abc> and other </abc> .

I know both are equal .I want to know how datastage decide which one.

is it controlled by XSD.if so how can ?

Please sharre your thought

t

Hi In following example the POLICY_CLAUSE_TYPE_CODE/> is in xml group which is repeated many times with null values because other xml group has distinct values.can you please let me know where in the stage to specify that so that the xml tags not repeated with same data. -<PolicyClausesDetails> <POL...

Hi
1) I want to omit null tags inside the xml group
I made column nullable and selected omit null tag option inside inside hierarchy stage. But I still see null tags. Please let me know how to fix this issue.
2) is there any may to remove duplicates in XML file before generating.


Thks

Hi

I enrolled for Premium membership and My profile is updated but I could not see complete message send by others.

Please fix this issue ..

My user name is sainath

Hi

Please share your feedback on above issue

thks

HI When data is null in my xml file I am getting following weird data www.w3.org/2001/....... data XSD : <xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema"> how to avoid this . </AssigneesDetails> ASS...

HI

I mean the below format.how can I achieve this using hierarchy stage
<element> </element> ..


thks

Sainath

Hi

In hierarchy stage where can I select the format of the output


I am getting the following one if input is null


<element-name/>

but I want

<element_name>/<element-name>

I tried to change in XSD no luck

please help

Hi

which stage is best option to generate the XML output for few records(1000) with proper validation rules .

if i want to use xml put stage where can i pass xsd information to validate xml


requirement is the straight forward mapping with out any transformation rules.


thks

sainath

Hi
From my understanding if you source from database and loading into target database in same job performance will be very slow
Do you have any sample design approach that can be followed

Thks

Hi
I am thinking quality stage or visual manual
Inspectiion