Datastage Interview Questions and Answers
Data Warehousing
Follow Us
TAGS
16. | What is universe stage? |
---|---|
A stage that extracts data from or loads data into a Universe database using SQL. Used to represent a data source, an aggregation step, or a target data table. |
17. | What is dynamic array? |
---|---|
Dynamic arrays map the structure of DataStage file records to character string data. Any character string can be a dynamic array. A dynamic array is a character string containing elements that are substrings separated by delimiters. |
18. | What is the difference between DataStage version 5.2 and 6.0? |
---|---|
Version 5.2 doesn’t have – IPC Stage ,Link Partition Stage,Link Collector Stage and Parallel Extender. |
19. | What are the components of Ascential Data Stage? |
---|---|
Client Components : Administrator, Director, Manager, and Designer. Server Components : Repository, Server and Plug–ins. |
20. | What are the types of Containers? |
---|---|
There are two types of containers are : Local Container Shared Container |