in the transformer stage? Can someone explain it in a little bit details?
Thanks.
what's the difference between SQL type and Data Element
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I am going to presume you are happy with what SQL data types are.
Data Elements are internal to DataStage. I like to think of them as "luggage tags" for data. For example, the SQL data type might be Char(10). What is it? A telephone number? A tax file number? A product code?
Data Elements allow you to create your own definitions, and to document the business rules associated with each. For example, it is meaningful to parse the area code from a telephone number, but not from a tax file number.
Consider a Data Element called Revenue. Performing a Usage Analysis on this Data Element can rapidly answer the question "which jobs process revenue?".
Data Elements are internal to DataStage. I like to think of them as "luggage tags" for data. For example, the SQL data type might be Char(10). What is it? A telephone number? A tax file number? A product code?
Data Elements allow you to create your own definitions, and to document the business rules associated with each. For example, it is meaningful to parse the area code from a telephone number, but not from a tax file number.
Consider a Data Element called Revenue. Performing a Usage Analysis on this Data Element can rapidly answer the question "which jobs process revenue?".
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.