parvathi

• Oct 2nd, 2007

Not clear with question. But you cannot directly link seq.file to other seq.file. you can give the link as?a reject link but no data will carry thru link.

Answer Question  Select Best Answer

parvathi

• Oct 2nd, 2007

Create a shell script like stg.sh and declare needed parameters for source and schema and target in run_dsjob program. Remember the parameters you used for script should be declared at source and target and give all parameters and job name all as parameters to run_dsjob.

subbu malepati

• Sep 3rd, 2006

Hi,use cmd line options../shellscript in the script use $1, $2 ... etc as arguments.regardsSubbu MalepatiBlore.

Answer Question  Select Best Answer

prasoon.pandey

 Profile Answers by prasoon.pandey Questions by prasoon.pandey

• Sep 18th, 2007

This only appears if the job identified by Job Name has Allow Multiple Instance enabled. Enter a name for the invocation or a job parameter allowing the instance name to be supplied at run timeAn '...

Answer Question  Select Best Answer

Adam

• Sep 17th, 2007

It's very difficult to have a good usgae analysis in oracle and see exactly who is touching what and how on table and column level. However I know that there is a good tool called DB*Classify that pro...

Answer Question  Select Best Answer

Want to convert Char to timestamp in transformer stage. Can anybody please tell me what conversion function I need to put in derivation?

I would like to know whether it is possible to create an outer join when I link the data from a HF to a transformer. The situation is I retrieve data from source table and transform them by using a transformer. From the very transformer, I need to take data from a hashed file so I create a link between the HF and the transformer. By default, the link is based on the equality of the 2 columns. But...

Mobashshar

• Aug 8th, 2007

What type of index are you looking for ? If it is only based on rows, use @inrownum or @outrownum

Answer Question  Select Best Answer

Fact table - Table with Collection of Foreign Keys corresponding to the Primary Keys in Dimensional table. Consists of fields with numeric values. Dimension table - Table with Unique Primary Key. Load - Data should be first loaded into dimensional table. Based on the primary key values in dimensional table, the data should be loaded into Fact table.

Siraj

• Aug 3rd, 2007

__________________                       _______________     _________...

sriram

• May 24th, 2007

When does ODS come in to picture ?I guess its like this                        &...

Answer Question  Select Best Answer

Raghu

• Aug 1st, 2007

Aggrigator cannot store the data onto disk like Sortstage Do the data landing.your system memory will be occupied by the data that is going to aggrigator.If your system memory is full then you get tha...

Answer Question  Select Best Answer

Raghu

• Aug 1st, 2007

Hashing is a technic how you store the data in dynamic files.There are few algorithams for doing this process.Read Data-statructures books for the algoritham models.Hash Files are created as dynamic files using hashing algoHTHRaghu Mule 

Answer Question  Select Best Answer

source has 10000 records, Job failed after 5000 records are loaded. This status of the job is abort , Instead of removing 5000 records from target , How can i resume the load

Raghu

• Aug 1st, 2007

There are lot of ways of doing this.But we keep the Extract , Transform and Load proess seperately.Generally only load job never failes unles there is a data issue.All data issues are cleared bef...

Answer Question  Select Best Answer

Raghu Mule

• Aug 1st, 2007

Archestrate is the old name for PX and EE. All the internal stages generally called Internal Operators in PX. You can write Custome operators if there is any necessity of enhancing the fucnctionality ...

Answer Question  Select Best Answer

Raghu

• Aug 1st, 2007

Type30 Files are Dynamic files.HTHRaghu Mule

Answer Question  Select Best Answer

shrine

• Aug 1st, 2007

Through user variable activity in sequencer Job. through calling a routine.

Answer Question  Select Best Answer

Fahmida

• Jul 31st, 2007

1.System Variables are inbuilt functions that can be called in a transformer stage2.Containers is a group of stages and links,thy are of 2 types,local containers and shared containers3.Using IPC,Manag...

Shiva

• Dec 13th, 2006

The following rules apply to the names that you can give DataStage jobs:? Job names can be any length.? They must begin with an alphabetic character.? They can contain alphanumeric characters and underscores.Job category names can be any length and consist of any characters,including spaces

Answer Question  Select Best Answer