Explain the purpose of Data elements

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
sudhakar_viswa
Participant
Posts: 85
Joined: Fri Nov 18, 2005 5:35 am

Explain the purpose of Data elements

Post by sudhakar_viswa »

Hi,

I have gone through the help.But i could not find the information about data elements.please explain about data elements.what is the use of data elements.And how to create and how to use the data elements

Thanks,

sudhakar
i need to know datastage
myotoo
Participant
Posts: 17
Joined: Sun Dec 04, 2005 11:19 pm

Post by myotoo »

Hi Sudhakar,

Go to DS help index tab, search for "data elements". It explains quite details how to create/use data elements.


M
sudhakar_viswa
Participant
Posts: 85
Joined: Fri Nov 18, 2005 5:35 am

Post by sudhakar_viswa »

Hi,

Now i came to know how to create data elements.But, i do not know the use of the data elements.Explain me

Thanks,
sudhakar
i need to know datastage
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Post by roy »

Hi,
Data Elements are optional.
Their pupose is to enable common language regarding simple or complex data element between developers.
Using then, building transformations between data elements to data elements and/or other types is solely up to the developer of the transformation.
i.e. what would you define as a phone_number type?
is it something like:
PhoneNum varchar(30)
Or is it:
Phone.CountryPrefix Decimal(3,0)
Phone.AreaCode Decimal(4,0)
Phone....

Once you have such types defined it is:
1. Very clear what you mean when you say Phone (as data type)
2. Easy to validate the info you have on a customer according to the types of the elements
3. Very clear and easy to convert between different formats, after you build the transformation transforms or routines.

The above is as they say " in a nut shell "

Again using Data Elelments id optional and is not enforced by DS in any way!

IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.

Search before posting:)

Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Image
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Data elements are cool. I think of them as "luggage tags" for data so that, for example, I can identify one ten digit number as a telephone number and another ten digit number as a part number and yet another ten digit number as a money amount with an implied decimal placeholder. Businesses (or auditors) are often very interested in being able to track "Money", "Revenue" and so on, which is readily accomplished by performing Usage Analysis on systematically, consistently and thoroughly applied data elements.
Data elements have neither meaning nor effect outside of DataStage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply