DSXchange

Thanks Ray for your response. The image of lookup stage and Range lookup rule is here.

http://i62.tinypic.com/ivgydd.png

Hi, I need your expert help for an issue with range lookup. My job is simple, input stream has a date, my reference has Fiscal Year, Start date and End Date. I need to get the fiscal year if the input date falls between start and end date. I've specified the range lookup exactly as mentioned in the ...

The job just reads from a table and writes to a dataset. I'm not writing data to output tables.

I have a Datastage job which reads just 500 records pivots each record into 100 records and later joins those 50000 records with other tables to make final count 300,000. The wierd problem is when I compile the job and run it, it takes 3 minutes to complete. If I rerun the same job it hangs forever....

I dont think it will cause a problem untill you have mutually exclusive records on each link. Records to be inserted wont go on the update link or delete link..same way deletes will only happen when there is no record in the source but corresponding record is in target...

Hi, I've a job 'TestJob_1' which extracts data from DB2 source and load it into oracle table. I've a sequence which calles this job. When I trigger the sequence, the sequence Aborts however the underlying job is successful... I tried multiple things but in vain.. Note- I've compiled the job and sequ...

Thank you very much for such quick response...

i have 270 columns in a single row...i need to place a constraint on a column name ..for example.. my input data is - Benefits_Amt Salary_Amt Reimbursements_Amt ...... 100 40 10 I want to put constraints such as...if the column name contains the word 'Reimbursements' ..then process A, if column name...

Thank you Kris..it is helpful information.

[quote="ray.wurlod"]Add an additional Specification containing only the word NOWARN. ...[/quote]

Hi Ray,

Where should i add the word 'NOWARN'? ...

will it be like this? -> MKTG_CHANNEL_CD: string = substring[1,2] (MKTG_CHANNEL_CD) NOWARN

If you have mentioned Truncate,try changing this to Replace and run the job.

I am using DS PX 8.1

But i dont see a Sequence Generator.

There is Column Generator,Surrogate key,Row generator.

Any Inputs?

Hello, What i am trying to do is --> 1> There is a set of input of 1000 customers. 2> I have to generate serial number - 1- 1000 against all these customers.Hence i used Column Generator stage. I define Count - Bigint and set Start numbering from 1,Increment by 1. 3>Now when i run the job first time...

my i/p is in following format... : ID | KEY | DIV 111 | 123 | G 111 | 345 | E 111 | 456 | E 111 | 323 | E I just require some guidance for this piece of input and rest i can work around the o/p transformation rule is --> for the same ID map the E key to G key so o/p should be ID | KEY | DIV 111 | 12...

Thanks everyone but still no luck.

What i dont understand is why the 1st two records are coming 001 while rest are being numbered correctly.

i have initialised stage variable as 0