DSXchange

kcbland wrote:Shouldn't

Code: Select all

If not(IsNull(DSLink86.Col1)) 
then 
Unit_Out.Col1 
Else 
if not(IsNull(DSLink89.Col1)) then DSLink89.Col1 
else @NULL 

be

[code ...

I am not geeting you exatly..Please expalin

Two lookups, use the results of one else if none then use the other. ... Thanks, I have used two hashed file lookups,And use the following logic in output column of transformer : If not(IsNull(DSLink86.Col1)) then Unit_Out.Col1 Else if not(IsNull(DSLink89.Col1)) then DSLink89.Col1 else @NULL DSLink...

Hi, I have an issue as follows. I have 2 source[1 flat file, 1 table].I need to look up the for data coming from the flat file to the table based on the following conditions: If the field1 in the flat file is equal to Col2 or Col3 of the table .i need to pass the curresponding Col1 [the key column o...

chulett wrote:Not much you can do there, it's a full table scan regardless of the indexes, which would not be used. You sure you don't mean 'Group by A' ? ...

insted of doing group by in query If i use aggregator stage ,Will it give any performane improvement..
Suggest.....

please post the exact and complete error from the log. Please. Also, what DSGuru posted goes without saying - the names must be the same, not should be. And on ... Hi, Thanks. I am getting the following error in director WDF..Staff_hash.Hash_staff: DSD.UVOpen Unable to open file '/ABC/Dasl/Hash_sta...

:? You are unable to create the hashed file, or to read it once you've created it? In any case, please post the exact and complete error from the log. ... Actaully i am not able to read hash file. From input stage to hash file the data got transfered.from threre i can not read,or view data.The link...

Hi, Have an issue as follows. I having a query from an input informix stage. select A ,Max( B ) from tab Where A not null and B not null Group by B Here both columns A,B are indexed. As the source table contains 5crores of records,the performance is very slow.[22row/Sec]. Please suggest a way to imp...

hi,

I getting the error while running the job with hash file lookup"unable to open hash file"I have used directory path option while creating the hash file.and i the input tab file name as input link name and in output tab output ink name.
Please help me out.

ray.wurlod wrote:Use instead of DSJ.PARAMTYPE.STRING ...

I have used DSJ.PARAMVALUE but still giving the same error.
Please suggest any alternative

Hi, I am have some proble while passing parameter from one job to another using the following manner UtilityRunJob('testJob', 'Par1=' : DSLink4.o_p_uid :'|' : 'DataSource=' : DSGetParamInfo(DSJ.ME,DataSource,DSJ.PARAMTYPE.STRING)) I am calling testJob from job ABCD par1 is taking from a file and the...

Hi, I am facing some problem while updating data from flat file to rdbload [Red bric data load plug in]. I want to update some columes based on the key values in the redbick ware house . In the plug in inputs->Properties tab i mention TMU Mode as update But it is not updating the fields. Please help...

Hi , I am geeting the following error while running the DS job.And got aborted Please help me out. Stlkp..Transformer_1: [Informix][Informix ODBC Driver]Unspecified System Error = -11103. SQLBindCol: Failed to bind result set column 'o_st_uid' for SQL statement: SELECT o_st_eid from o_st where o_st_...

DSguru2B wrote:Are you using ODBC stage for lookup. Because only that stage supports multiple row returns. Search on keywords "Reference lookup generated %d rows. Only the last row was used" to get more posts relating to your error.

Thanks,I am using INformixCLI stage

Hi, Please Suggest me a solution for the below issue. I want to perform a look up operation ,for that i have one column TAB1.A of [Non Key] from the source and i wanated to look up to TAB2.A [key column in that table] and populate some values from TAB1 and TAB2 to Target. When i was running the job ...

You can pass the parameters delimited by | characters. Row limit is the number after which the job need to be stopped. And the Warning is the limit is the number of warning after which thejob will abort. You can use the input values read from file as argument. Thanks. I have two columns Col1 and Co...