DSXchange

Hi, I'm loading 21 million records in a Oracle table and it is taking around 1 hr 30 Minutes to load using Oracle Connector. I used Bulk Load as well as Insert Mode in Oracle. Surprisingly, in both modes Bulk as well as Insert Mode job is taking same time to load. More surprisingly Bulk mode is taki...

Yes, Thanks Mike, I'm creating Temp Table in DB with those variables as column and then doing custom derivation in SQL and it is working.

Hi Mike, thanks but please advise "bunch of nested if else" what do u mean?

I'm getting following value of derivation in column flag_value from a table if ((currentMonth <= 3 and ( ((mbrSubPlnAdjEndDt ="") or ((mbrEnrEndDtMonth >= 1) and (mbrEnrEndDtYear >= (currentYear - 1)))))) or (currentMonth > 3 and ( ((mbrSubPlnAdjEndDt ="") or ((mbrEnrEndDtMonth >...

In Oracle connector stage I'm executing one After SQL after loading a table. I have set After SQL fail to "No". That is if the After SQL statement fails due to any constraint or any issue then job should not fail. However my job is still throwing a warning due to the failure of After SQL s...

I'm doing a sparse lookup on oracle table on Key but when I'm running job I'm getting error as Dropping component Key because of prior component with same name Key. Actually the column for which it is saying it is dropping due to same name is lookup key only and usually we get this error for other j...

Hi, I'm converting a server job to parallel job. In server job a file is read and using transformer stage a lookup is done on DB using ODBC stage. My query is if there are multiple records in DB for an input record whether multiple records will be output or any random sigle lookup will be done and o...

I think you want to run in parallel assuming your number of files are fixed always & in that case generate a csv file with whatever Parameter set, file name and invocation id you want to pass then using execute command execute sed, cut to get parameter values for each instance and execute parall...

I think this is the answer

select *from table1 t1
inner join table t2
on t1.col1=t2.col1

where col1 - lookup column & as condition t2.col2='ABC' is not dropping any record it is not required in query.

It is working, thanks.

chulett wrote:

prasson_ibm wrote:Try to read the file with comma delimited and do not mention double quote in the job in file definition.

So their four columns will read / be parsed as six? Not really sure how that will help.

Yes, I agree this will not work.

I had tried using unstructured stage but it is not working for csv and in no way parallel job sequential file is working for this. As you said server sequential will work will try it but I'm thinking how we can handle quotes in a particular column as in some case we will get quotes for a column and ...

I'm getting input csv file as 1,"2,2.1",3,"4,4.1". This sample record is having 4 columns with value in first column 1, second column 2,2.1, third column 3 & fourth column 4,4.1, i.e. columns having comma is enclosed in double quotes. Double quotes can be on any column if it'...

Hi, In a column when I get value as abc"xyz", I need output as "abc""xyz"". I'm using dquote function but i'm getting output as "abc\"xyz\"".

Could you please suggest is there any simple logic to get "abc""xyz"".

There's an even simpler way: use the export to file function in Administrator's environment variables screen. You can temporarily create an encrypted variable, give it the "value" of $PROJDEF, and examine the exported file. Your encrypted string will be there. thanks, I tried it, this is ...