• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

Administrator in Data Stage

Administrator

For a Specific project

Project

Add create protected project

Ok

In, if we don’t have web console, In 8 we have wed console, and same permissions are given here Add check points.

Tracing 

Reporting the activities  that are requested by  the client at server .

How can you delete logs in Repository ?

Sol :- Auto purge  of Job logs.

RCP:-  Job properties  :-  Entire RCP

  • Enable Runtime column propagation 11Violating Mapping constraints According to Requirements

Data Quality

Screenshot_104

 

111 person data is stored in 3 different ways such a data is called Dirty Data.

11for,      Credit :  100 cores  * 100 customers  = 10, 000 cores

But here out of 100 %, only 60 % are unique customers

  • 100 = 6000 cores

114000 cores is the un necessary cost used.

àHere IBM comes in to picture  and says that pay me 1000 cores, using Data quality we eliminate remaining 40 %

11So, here using Data Quality , we are eliminating the Duplicate records.

Inclined to build a profession as DataStage Developer? Then here is the blog post on DataStage Training.

Reasons  for Dirty data

  1. lock of information Standards
  2. 1 field is used for Multiple

Data in a data base is after misplaced.

Data Redundancy

Data is required in to Systems, because the data entry mechanism is not aware that the original  record is already there.

To perform Data Quality , we have 4 stages :-

 

Screenshot_105

 

 

Survive Stage :-  Consolidate

Screenshot_106

 

Power of Data Quality in Result set

Rules set11For name

For address

For Social Security

EX :- for Name :-

 

Screenshot_107

 

Designer 

View 11 Repository 11 Standardization    Rules11USA 11US NAME

 

EX :-

Screenshot_108

 

 

(c) Container –  Standardize

 

Screenshot_109

For indepth understanding of DataStage click on

Summary
Review Date
Reviewed Item
Administrator in Data Stage
Author Rating
5

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on Administrator in Data Stage"

Leave a Message

Your email address will not be published. Required fields are marked *

Site Disclaimer, Copyright © 2016 - All Rights Reserved.