DSXchange

My bad! Will learn to read the content before jumping to a solution next time

What if you business key is a composite key containing 10 columns? Then you would have to update records based on 10 keys. The FACT will also have these 10 columns and assuming that you have 10 dimensions each with an average of 5 key columns, your FACT would end up with 50 keys! Add the measures to...

The lag is being caused by the way buffers work in DataStage and is an essential. You might want to have a look at the "score" to ensure that no unnecessary repartitioning is happening. Also, if your Transformer is not implementing any business logic and is just performing minor conversion...

Not too sure what you are looking for but I think "iconv" can do the job for you.

Syntax: iconv -f encoding -t encoding

SURA wrote:varchar2(255)
VS
varchar(255)

Sorry, I meant varchar(255)

Thanks for the reply. I did not create the schema manually. In fact, I am sourcing it from an Oracle table.

The actual lookup is being performed on two keys - one of which is this varchar column and the other is an integer. Could this be a problem though I don't see any reason for that.

Hi All,

I am trying to do a case insensitive lookup on a varchar2(255) NOT Nullable column but am getting the following warning

Unrecognized Type specific format: {case-insensitve} on Key "COL_NM".

What could the reason be?

Hi, This was a question that came in a brain storming session and I was wondering if any of you have encountered this before. Assume, we load 10 different tables in 10 parallel jobs all within the same sequencer. Let us also assume that all these laods happen sequentially because of integrity requir...

Just so I understand, you need all empno from emp_1 that are not present in emp_2, right? Off the top of my head, I can think of a design with a lookup. The primary link will have emp_1 data and the reference link will have emp_2. perform a lookup on empno. The data rejected by the lookup would be t...

1. Create a single job with a source connector that extracts data for one location. This condition should be parametrized (e.g. WHERE LOCATION=#jp_Location_Nm#). 2. Implement your logic and create a file where again the file's name should be parametrized (e.g. File Name= Target_#jp_Location_Nm#). 3....

ha...i am not yet a seasoned campaigner to justify the presence of a server component in my jobs!

I'm not sure if I'd want to use server components in my parallel job. Will look into the UNIX command. Thanks you!

Hi, I came across this interesting requirement. Pardon me if this has already been discussed but I couldn't find it anywhere. I have a source table with columns: Name, Age, Location The Location column can contain any value and is not fixed. For e.g. It may contain New York. it may also contain US. ...

Add the environment variable $OSH_PRINT_SCHEMAS. The runtime schema will be made available to you in Director logs.

Not sure if this is what you are looking for

Not too well versed with the native scheduler but does it not have a 'File Watcher' equivalent? Pardon my lack of knowledge with the scheduling department.