DSXchange

Ray - is this set at a job level or project level. Can you pls help me to understand where these are set?

Satish

I modified the job and implemented SCD2 in the old fashion way not using the SCD stage provided datastage. Below is the functionility: - if a new record is found it inserts - if an existing record is found, it end dates the existing record in the DIM and - and open a new record . So, the job has 2 i...

I modified the job and implemented SCD2 in the old fashion way not using the SCD stage provided datastage. Below is the functionility: - if a new record is found it inserts - if an existing record is found, it end dates the existing record in the DIM and - and open a new record . So, the job has 2 i...

That setting is already defined. Not sure where the issue is.

I am trying to build a individual dimension and I am using a SCD stage. This stage has 2 inputs and 2 outputs - Staging data input - DIM lkp input - DIM_Insert Output - DIM_Update output I get the following error with a SK function "The function NextSurrogatekey() cannot be called from column '...

What is the purpose of Node map constraint. When I open the browse option, I have 4 nodes listed. When do I choose a single node vs multiple nodes. Pls help me understand this piece.

Also have this in the job properties for $APT_ORACLE_LOAD_OPTIONS:

OPTIONS(DIRECT=FALSE,PARALLEL=FALSE)

This is my job design: Oracle Ent Stage --> Copy --> Seq.File Oracle Stage: - have a SQL override with conditions rownum < 50000 - Buffering is default - Combinability - Auto - Preserve partition default Copy Stage: - Preserve partition propagate - Auto Partitioning Seq File: Default settings Thanks

Even if I remove the nodes in the Nodemap constraint, it still is duplicating based on the number of nodes.

We have a simple job that uses a direct table to table dump with a Copy stage in between. This is what we did: - We created 2 logical nodes in the config file and used that config file in the current job - Added the 2 nodes in the node map constraint field - Rest of the options are defaults. When I ...

I have a stream inout and 1 reference input with a lookup. I have the 3 conditions - 2 Range lookups in the streams key expression - 1 Equality lookup in the reference When I am doing this the output is messy. If i use either of the range lookups or the equality lookup, the output is as expected. Bu...

Ray - Can you pls tell me how do we put another AND condition. I did not have an option to add another condition there. I think I am missing something here. Can you pls explain? Thanks. Your question embodies the solution. On the reference input link in the Lookup stage choose Range as the lookup ty...

This is how my job looks like: [code] Ora_Ent_Stage_main --> Lookup_stage--> FLat_File : : Ora_Ent_Stage(LKP) [/code] 1. Disp_DT is coming from the Ora_ent_stage_main 2. Other dates - t_start_dt, t_end_dt, s_start_dt and s_end_dt comes from the reference table - Ora_Ent_Stage(LKP) I could only do th...

I have a ID1 and date col coming from a stream input called disp_dt. Now there is a reference table where we have the following columns ID2 t_start_dt t_end_dt s_start_dt s_end_dt I am getting both these inputs to a lookup and I want to perform the following: 1. ID1=ID2 2. disp_dt >= t_start_dt and ...

Is your C++ compiler properly licensed? ... I think so. I downloaded it from MS site. It had a free download i guess. I did the following: 1. Installed Windows Platform SDK for 2003 2. Installed Visual C++ 2005 Express Edition 3. Installed IS 4. Set the path to the APT_Linker and APT_Compiler to C:...