Datastage Tutorial
Datastage Tutorial for beginners and experts.
Articles
What type of data available in Datawarehouse?
2011-11-01 23:29:00
What type of data available in Datawarehouse? Data in the Datawarehouse comes from the client systems.Data that you are using to manage your business is very important to do the manupulations according to the client requirements.
2011-11-01 23:29:00
What type of data available in Datawarehouse? Data in the Datawarehouse comes from the client systems.Data that you are using to manage your business is very important to do the manupulations according to the client requirements.
How to Improve Performance of Datastage Jobs?
2011-11-01 23:20:00
How to Improve Performance of Datastage Jobs?Performance of the Job is really important to maintain.Some of the precautions are as follows to get good performance of the Jobs.Avoid the use of only one flow of tuning for performance testing or tuning testing.Try to work in Increment. Isolate and solve the Jobs. And Work in increment.
2011-11-01 23:20:00
How to Improve Performance of Datastage Jobs?Performance of the Job is really important to maintain.Some of the precautions are as follows to get good performance of the Jobs.Avoid the use of only one flow of tuning for performance testing or tuning testing.Try to work in Increment. Isolate and solve the Jobs. And Work in increment.
What is Flow of Loading data into the fact and Dimensional tables.
2011-10-11 13:33:00
What is Flow of Loading data into the fact and Dimensional tables.Source Data is first loading into the staging area and where data cleansing takes place. And the data coming from staging area will be loaded into the dimensions or lookup. And finally fact tables are loaded from the corresponding source tables from the staging area. Datastage interview questions.
2011-10-11 13:33:00
What is Flow of Loading data into the fact and Dimensional tables.Source Data is first loading into the staging area and where data cleansing takes place. And the data coming from staging area will be loaded into the dimensions or lookup. And finally fact tables are loaded from the corresponding source tables from the staging area. Datastage interview questions.
Difference between Datastage and Informatica.
2011-09-06 01:57:00
Difference between Datastage and Informatica.Difference between Datastage and Informatica is Datastage is having Partition, Parallelism, Lookup , Mege etc But Informtica Doesn't have this concept of partition and parallelism. File lookup is really horrible
2011-09-06 01:57:00
Difference between Datastage and Informatica.Difference between Datastage and Informatica is Datastage is having Partition, Parallelism, Lookup , Mege etc But Informtica Doesn't have this concept of partition and parallelism. File lookup is really horrible
What is the use of Nodes.
2011-08-16 11:33:00
What is the use of Nodes. In a Grid environment a node is the place where the jobs are executes. Nodes are like processors , if we have more nodes when running the job , the performance will be good to run parallel to make the job efficient.
2011-08-16 11:33:00
What is the use of Nodes. In a Grid environment a node is the place where the jobs are executes. Nodes are like processors , if we have more nodes when running the job , the performance will be good to run parallel to make the job efficient.
What is Job Commit ( in Datastage)
2011-08-16 11:28:00
What is Job Commit ( in Datastage) In DRS Stage we have a transaction Isolation , set to read committed . And set Array Sze and transaction size to 10,2000 . So that , it will commit for every 2000 revords.
2011-08-16 11:28:00
What is Job Commit ( in Datastage) In DRS Stage we have a transaction Isolation , set to read committed . And set Array Sze and transaction size to 10,2000 . So that , it will commit for every 2000 revords.
How to CONVERT A MM/DD/YYY format to yyyy-dd-mm
2011-08-16 11:21:00
How to CONVERT A MM/DD/YYY format to yyyy-dd-mm We can use the Oconv and Iconv Functions. Oconv(Iconv(Filedname,"d.mdy[2,2,4]"),"d-ydm[4.2.2]").
2011-08-16 11:21:00
How to CONVERT A MM/DD/YYY format to yyyy-dd-mm We can use the Oconv and Iconv Functions. Oconv(Iconv(Filedname,"d.mdy[2,2,4]"),"d-ydm[4.2.2]").
Why we use Look-up Stage?
2011-07-20 22:39:00
Lookup Stage is a processing stage which performs horizontal combining. Lookup stage mainly used to map the short codes in the input dataset onto expanded information from a look up table . For example, if you have an state as a three letter QLD State postal code, but you want the data to carry full name of the state. We can define a lookup table that carries a list of codes matched to states.
2011-07-20 22:39:00
Lookup Stage is a processing stage which performs horizontal combining. Lookup stage mainly used to map the short codes in the input dataset onto expanded information from a look up table . For example, if you have an state as a three letter QLD State postal code, but you want the data to carry full name of the state. We can define a lookup table that carries a list of codes matched to states.
What is RCP?
2011-07-20 22:37:00
RCP is nothing but runtime column propagation. When we send the data from source to the target, some times we need to send only required columns . In this time, if we like to send only required columns to the target we can do it by enabling the RCP Option.
2011-07-20 22:37:00
RCP is nothing but runtime column propagation. When we send the data from source to the target, some times we need to send only required columns . In this time, if we like to send only required columns to the target we can do it by enabling the RCP Option.
What is Stable Sort?
2011-07-20 22:36:00
Stable sort is one of the option in Sort Stage. When we enable the Stable Sort, this will make sure that the data will not re-arranged , if it is already sorted in the previous stage.
2011-07-20 22:36:00
Stable sort is one of the option in Sort Stage. When we enable the Stable Sort, this will make sure that the data will not re-arranged , if it is already sorted in the previous stage.