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
Search found 135 matches
- Mon Jan 27, 2020 7:49 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: compilation error for SCD stage
- Replies: 0
- Views: 3819
- Tue May 14, 2019 12:50 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Field length more than 8000
- Replies: 3
- Views: 3704
Field length more than 8000
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
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
- Thu Mar 21, 2019 12:55 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Logic
- Replies: 3
- Views: 3349
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...
- Thu Mar 21, 2019 10:18 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Logic
- Replies: 3
- Views: 3349
Logic
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
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
- Sun Dec 23, 2018 3:31 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: hierarchy xml stage
- Replies: 2
- Views: 3352
hierarchy xml stage
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
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
- Mon Dec 17, 2018 6:44 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Hierarchy stage XML
- Replies: 1
- Views: 2703
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...
- Mon Dec 17, 2018 2:47 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Hierarchy stage XML
- Replies: 1
- Views: 2703
Hierarchy stage XML
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
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
- Sat Dec 08, 2018 6:54 am
- Forum: Site/Forum
- Topic: Premium Membership
- Replies: 1
- Views: 12458
Premium Membership
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
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
- Fri Dec 07, 2018 4:10 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML DATA from hierarchy stage
- Replies: 4
- Views: 4072
- Wed Dec 05, 2018 2:14 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML DATA from hierarchy stage
- Replies: 4
- Views: 4072
XML DATA from hierarchy stage
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...
- Mon Dec 03, 2018 1:47 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Hierarchy stage <element/> tags
- Replies: 4
- Views: 4157
- Mon Dec 03, 2018 11:45 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Hierarchy stage <element/> tags
- Replies: 4
- Views: 4157
Hierarchy stage <element/> tags
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
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
- Sun Aug 26, 2018 10:56 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: xml output stage vs hierarchy stage
- Replies: 1
- Views: 2891
xml output stage vs hierarchy stage
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
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
- Sun May 07, 2017 7:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job design
- Replies: 5
- Views: 3993
- Mon Apr 17, 2017 10:13 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Etl logic
- Replies: 5
- Views: 3420