DSXchange

Hello Gurus, Need your expertise idea to crack below requirement. I have lookup table where i have maintained condition or constraints Like E.g Table1 Key V_SQL 1 Name = 'P' 2 Name = 'Q' So I will join the main data with lookup table based on the key and pass the value has constraint or condition in...

I have requirement to generate the sequence number for the duplicate enteries.

For Example

ID,Seq_number
10,1
10,2
20,1
20,2
30,1
30,2
30,3
30,4

Any suggestion Appreciated

Thanks In Advance

Hi Chulett, Yeah your are right ,So going with experts words i have designed job ExternalSource--->Xmlinput---->Peak ,The job is succesful and providing me the acrute results. Before i mark this post a resolved, Can you please share me how to handle rejected record in Xml Input stage to peek stage ,...

Hi Chulett, It will cumbersome to write derivation for each tag,because we have more tags. Noted:The only reason i opted to perform above because xml input stage requires XSD stored some where and results the warning stating "The primary document entity could not be opened". Can u suggest ...

Hi, My source record is as below: <POLICY_COVERAGE_ROW><REPORT_DT>201302</REPORT_DT><POLICY_NO>130201LD01</POLICY_NO></POLICY_COVERAGE_ROW> How do i generate pieline delimiter file only with tag value as shown below using datastage. 201302|130201LD01 Noted:I dont want to use Xml input stage to do th...

Hi All, I want to pass the sql statement in the runtime using parameters property in datastage.How to achieve this? For Eg: I want run the below sql. delete from <Table_name> where <batch_load> = <date> in a parameters in runtime How to perform the above,Please let me know. Thanks for your help in A...

Hi All,

How we can represent ASCII-127 Character (HX-7F) as a delimiter in datastage.

"I Mean what value i have pass in the delimiter String"

Thanks for your help in advance.

U can directly check the value in a particular range. Indeed, anyone can, not just U (one of our posters). The descriptions in the manual are quite clear. Show us what you have attempted. Hi Ray, I have drived the Table1 has my primary and while i perform look up with Table2(which is reference),I c...

kadale.nilesh wrote:Range lookup is support in datastage 8x. U can directly check the value in a particular range.

Can you elaborate how can i do that,If any Condition let me know based on my example.

Thanks for help in Advance.

Hi All, I have Requirement to reterive the id based on the range of value,Please help to resolve this. Eg: Table1: Date1 Date2 AGE_Diff 20-01-2010 20-10-2010 9 Table2: id MIN_VALUE MAX_VALUE 1 1 5 2 6 10 3 11 100 How to loookup Table1.AGE_DIFF to Table2.MIN_VALUE,MAX_VALUE(based on the range) i have...

antonyraj.deva wrote:Is the job getting aborted because of this?

I've seen this message in few of my jobs but the jobs will run fine despite this message.

We have constraint of 25 warning in a job,so it is failing through automation.

Please help me to crack this.

antonyraj.deva wrote:Is the job getting aborted because of this?

I've seen this message in few of my jobs but the jobs will run fine despite this message.

We have constraint of 25 warning in a job,so it is failing through automation.

Please help me crack this.

Hi All, can any one help me,How to eliminate the below warning. "Exporting nullable field without null handling properties" Note : I have handled nullability to all the Char fields . Even i am using column export stage to export all the fields to to single field. Thanks for your reply. reg...

Hi all,

I have requirement,Please help me how to Achieve these

Input Output
AD-ADE-0000000001 0000000001
AF-ADF-0000000002 0000000002

Thanks for your help in Advance.

Hi All

How to resolve the issue.

lookuptable.20100417.stsv13d": No space left on device.

Can we do any tuning in the job.since we cannot increase the resource space for this job alone

This job is having single lookup holding 5 reference.

Thanks for your help