What are the main features of datastage?
DataStage has the following features to aid the design and processing required to build a data warehouse :
Uses graphical design tools. With simple point and click techniques you can draw a scheme to represent...
Datastage Scenario Based Questions with Answers
Datastage Scenario Based Questions with Answers
Datastage Scenario Based Questions with Answers:
Question1 :
Input :
source,destination,km
hyd,bang,1000
delhi,chennai,1500
chennai,bang,600
bang,hyd,1000
bombay,pune,1000
bang,chennai,600
Output :
source,destination,km
hyd,bang,1000
delhi,chennai,1500
chennai,bang,600
bombay,pune,1000
see...
20 Datastage Interview Questions for Experienced PDF Download
Datastage Interview Questions for Experienced PDF Download
1) What is Datastage ?
Design jobs for Extraction, Transformation and Loading(ETL).
Ideal tool data integration projects such as data warehouses, data marts and system migrations
import,...
Datastage Scenario Based Questions - Part 3
Datastage Scenario Based Questions - Part 3
1. Consider the following product types data as the source.
Product_id, product_type
------------------------
10, video
10, Audio
20, Audio
30, Audio
40, ...
Datastage Scenario Based Questions - Part 2
Datastage Scenario Based Questions - Part 2
1. Consider the following employees data as source?
employee_id, salary
-------------------
10, 1000
20, 2000
30, 3000
40, 5000
Q1. Create a job to load the cumulative...
Datastage Scenario Based Questions and Answers for Freshers and Experienced
Datastage Scenario Based Questions and Answers for Freshers and Experienced
1. Create a job to load the first 3 records from a flat file into a target table?
2. Create a job to load the last 3 records from a flat file into a target table?
3....
What is Partition in Oracle 11g with Example
What is Partition in Oracle with Example
PARTITIONS
Partitioning is powerful functionality that allows tables, indexes, and index-organized tables to be subdivided into smaller pieces, enabling these database objects to be managed and...
Anonymous on 
