DSXchange

It is working if it is direct match,but i have situation to check if the lookup file columns has ANY that means what ever the incoming value it is matched(becuase of ANY) and also i have some other conditions to match. That is the reason i am asking is there any way i can just read each line from th...

Thanks for your help.Instead of location the incoming values is there any way i can read the COMMON block line by line and do comparison.

Incoming : 100,200,300

Lookup file : 100,ANY,300,I

Output : 100,200,300,I

Here ANY means match with any incoming value.

Thanks

I never used COMMON block,Please give me some sample so that i can develop the remaining code.

I never used COMMON block,Please give me some sample so that i can develop the remaining code.

OPENSEQ InputFile TO File Then Loop Until Done Do READSEQ LINE FROM File Then SERVICE_GROUP_CODE = FIELD(LINE,",",1) SOURCE_SYSTEM_ID = FIELD(LINE,",",2) PLACE_OF_SERVICE_CODE = FIELD(LINE,",",3) CLAIM_TYPE_IND = FIELD(LINE,",",17) If SERVICE_GROUP_CODE<>&quo...

OPENSEQ InputFile TO File Then

Hi, I have a situation where i need read a file using sequential file stage and then do lookup using sequentil file only (lookup includes range,ANY...) Is there any way i can read the entire file in memory using basic routine and use that for each incoming record to do a lookup. Currently i am using...

Hi,

I have situation where i need to split a record into multiple records based on date.

InputData :

ID|BeginDate|EndDate
100|2009-01-01|2009-03-31

OutPut :

100|2009-01-01|2009-01-31
100|2009-02-01|2009-02-28
100|2009-03-01|2009-03-32

Any thoughts how to implement this un datastage

Hi, I am reading from a oracle table which not partitioned.But if i use PartitionTable option in Oracle enterprise stage to the read this unpartitioend table i see the performance improvement. Can any one pelase explain me when we need to apply partitiontable option.What is the use of this option ev...

Is there any performance difference between join and merge stage except merge has a reject link and join does not have.

Thanks

I would like to what information will be stored in &SAVEDLISTS& folder.I saq like what ever i executed in datastage command line all the information is stored in &SAVEDLISTS& folder.If i delete those files it will affect the project. can anyone please tell me what is the importance o...

Hi,

What is the use of force property in copy stage.When we need choose true or false.It influence any performance.

Thanks

Thaks ray for your valuable information. When i queried RT_STATUS i am getting the values like below SELECT EVAL "@RECORD<1>",EVAL "@RECORD<2>",EVAL "@RECORD<3>",EVAL "@RECORD<4>",EVAL "@RECORD<5>" FROM RT_STATUS1467; @RECORD < 1 > @RECORD < 2 > @REC...

Hi,

Is there any way can we get how many instances of a particular job ran with out using a director.

Thanks

I have areuqirement like below.

I need to find the max value by grouping on two columns.If even if i have a negative value but i need to take absolute value but in the output i need to populate originaal value.



Input data:

100,200,-5
100,200,1
100,200,-4

Output :
100,200,-5

Thanks