vimalt

 Profile Answers by vimalt Questions by vimalt

• Jul 13th, 2006

In Informatica powercenter, there is a way to implement slowly changing dimension through wizard. Datastage does not have that type of wizard to implement SCD, should be implemented by manual logic.Thanks,Vimal T

Ajit

• Jul 5th, 2006

Slowly changing dimensions is concept of DWH. Datastage is tool for ETL purpose not for Slowly changing dimensions. Does any one has any idea?

Answer Question  Select Best Answer

Navatha

• Jul 6th, 2006

The different hashing algorithms are designed to distribute records evenly among the groups of the file based on charecters and their position in the record ids.When a hashed file is created, Separati...

Answer Question  Select Best Answer

Saket Garg

• Jul 4th, 2006

Hi You can inprove performance of hashed file by 1 .Preloading hash file into memory -->this can be done by enabling preloading options in hash file output stage 2. Write caching options -->.It ...

Answer Question  Select Best Answer

shiva

• Jun 29th, 2006

JCL defines Job Control Language it is ued to run more number of jobs at a time with or without using loops. steps:click on edit in the menu bar and select 'job properties' and enter the parameters ...

Answer Question  Select Best Answer

kmalla

 Profile Answers by kmalla Questions by kmalla

• Jun 29th, 2006

Using Row Count system variable

Answer Question  Select Best Answer

shiva

• Jun 29th, 2006

Parallel extender is that the parallel processing of data extraction and transformation application . there are two types of parallel processing 1) pipeline parallelism 2) partition parallelism.

omkar

• Apr 23rd, 2006

its a new version of datastage called PX it process data using partion/collection methods (algorithms) it is very fast compare to older (server) version..partioning can be defined via Config file whic...

Answer Question  Select Best Answer

shiva

• Jun 29th, 2006

These are the three types of files will be created .dat, .type, .over

Answer Question  Select Best Answer

shiva

• Jun 29th, 2006

We use Link Partitioner in DataStage Server Jobs.The Link Partitioner stage is an active stage which takes one input andallows you to distribute partitioned rows to up to 64 output links.

Answer Question  Select Best Answer

shiva

• Jun 29th, 2006

go to the path /DATASTAGE/PROJECTS/DSENGINE/BIN/uv -admin -stopuv -admin -start

Answer Question  Select Best Answer

Radhika

• Jun 27th, 2006

Hi,I am using DataStage 7.5, Unix.  we can use shared container more than one time in the job.There is any limit to use it. why because in my job i used the Shared container at 6 flows. At any time only 2 flows are working. can you please share the info on this.Thanks,Radhika

Sharanu Patil

• Feb 28th, 2006

Sure ,u can use no doubt abt that

Answer Question  Select Best Answer

Guest

• Jun 12th, 2006

When we say "Validating a Job", we are talking about running the Job in the "check only" mode. The following checks are made :- Connections are made to the data sources or data warehouse.- SQL SELECT ...

aranjan

 Profile Answers by aranjan Questions by aranjan

• Jun 12th, 2006

When you compile a job, it ensure that basic things like all the important stage parameters has been set, mappings are correct, etc. and then it creates an executable job. You validate a com...

Answer Question  Select Best Answer

Hanu

• Jun 8th, 2006

Hi,Theare are the variables used at the project or job level.We can use them to to configure the job ie.we can associate the configuration file(Wighout this u can not run ur job), increase the sequent...

Answer Question  Select Best Answer

Alok Ranjan

• Jun 8th, 2006

Someone was saying that join does not support more than two input , while merge support two or more input (one master and one or more update links). I will say, that is highly incomplete information. ...

Unknown

• Jun 8th, 2006

Merge and Join Stage Difference :1. Merge Reject Links are there 2. can take Multiple Update links3. If you used it for comparision , then first matching data will be the output .Because it uses the update links to extend the primary details which are coming from master link

Answer Question  Select Best Answer

Zabi81

 Profile Answers by Zabi81 Questions by Zabi81

• Jun 1st, 2006

To answer your question the DRS stage should be faster then the ODBC stage as it uses native database connectivity. You will need to install and configure the required database clients on your DataSta...

Venkat

• May 22nd, 2006

DRS and ODBC stage are similar as both use the Open Database Connectivity to connect to a database. Performance wise there is not much of a difference.We use DRS stage in parallel jobs.

Answer Question  Select Best Answer

Zabi81

 Profile Answers by Zabi81 Questions by Zabi81

• Jun 1st, 2006

Obsuletely Yes.

MF

• May 25th, 2006

Friends, please try to write correct English first. Use a word processing software. A question becomes quite different when incorrect English is used.I am rewriting your question in correct Engli...

Answer Question  Select Best Answer

Zabi81

 Profile Answers by Zabi81 Questions by Zabi81

• Jun 1st, 2006

Hi,1. If u want to know some job is a part of a sequence, then in the Manager right click the job and select Usage Analysis. It will show all the jobs dependents.  2. To find how many jobs are us...

Answer Question  Select Best Answer

Krishnarao j

• May 30th, 2006

What is type 30,17...

shameerok

• Mar 22nd, 2006

yes you can implement Type1 Type2 or Type 3. Let me try to explain Type 2 with time stamp.Step :1 time stamp we are creating via shared container. it return system time and one key. For satisfying the...

Answer Question  Select Best Answer

arun

• May 30th, 2006

  if the job have good logic that is called as complex job.simply we can say Scenarios .so If you have faced any complexity while creating job please share with us.  

RamaPrasad Batchu

• Mar 10th, 2006

Complex design means having more joins and more look ups. Then that job design will be called as complex job.We can easily implement any complex design in DataStage by following simple tips in terms o...

Answer Question  Select Best Answer

Ravi

• May 28th, 2006

Question should be more detailed. I am assuming that there are too many stages, which is causing problem and providing the solution.In general. if you too many stages (especially transformers , h...

Answer Question  Select Best Answer