Wednesday, 4 February 2015

DATASTAGE Frequently asked Questions and Answers pdf (Part5)

41. How we can reuse the components?
Using the Shared and Local Containers.

42. What is the difference between primary key and partition key?
Primary Key is a combination of unique and not null. It can be a collection of key values called as composite primary key. Partition Key is a just a part of Primary Key. There are several methods of partition like Hash, DB2, and Random etc. While using Hash partition we specify the Partition Key.

43. How do you eliminate duplicate rows?
Data Stage provides us with a stage Remove Duplicates in Enterprise edition. Using that stage we can eliminate the duplicates based on a key column.

44. How we can reuse the components?
Using the Shared and Local Containers.

45. What is transformer stage?
Transformer stages do not extract data or write data to a target database. They are used to handle extracted data, perform any conversions required, and pass data to another Transformer stage or a stage that writes data to a target data table.

46. What are the command line functions that import and export the DS jobs?
dsimport.exe : imports the DataStage components.
dsexport.exe : exports the DataStage components.

47. Did you use the conditional scheduling in your project?
Using Sequencer Job we can create the conditional scheduling.

48. How do u handle the version controls?
Ascential have a separate product called ( Version Control ),which is used to handle version control.

49. What are stage variables?
Stage variables are declaratives in Transformer Stage used to store values. Stage variables are active at the run time. (Because memory is allocated at the run time).

50. What can we do with DataStage Director?
Validating, Scheduling, Executing and Monitoring Jobs (server Jobs).
More Questions & Answers :-
Part1  Part2  Part3  Part4  Part5

No comments:

Post a Comment