{"id":2719,"date":"2025-08-18T10:18:24","date_gmt":"2025-08-18T10:18:24","guid":{"rendered":"https:\/\/blog.daiconext.com\/?p=2719"},"modified":"2025-08-18T20:54:18","modified_gmt":"2025-08-18T20:54:18","slug":"erwin-data-modeler-teradata","status":"publish","type":"post","link":"https:\/\/blog.daiconext.com\/index.php\/2025\/08\/18\/erwin-data-modeler-teradata\/","title":{"rendered":"Crear un Modelo: Erwin Data Modeler &#8211; Teradata"},"content":{"rendered":"\n<h1 class=\"wp-block-heading\">Creando un modelo en Erwin Data Modeler con base de datos Teradata<\/h1>\n\n\n\n<p>En este art\u00edculo vamos a recorrer paso a paso c\u00f3mo crear un modelo en <strong>Erwin Data Modeler<\/strong> utilizando como motor de base de datos <strong>Teradata<\/strong>. Tomaremos como ejemplo un conjunto de entidades comunes en un escenario de negocio:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Cliente<\/strong><\/li>\n\n\n\n<li><strong>Factura<\/strong><\/li>\n\n\n\n<li><strong>Producto<\/strong><\/li>\n\n\n\n<li><strong>Categor\u00eda<\/strong><\/li>\n\n\n\n<li><strong>Usuario<\/strong><\/li>\n\n\n\n<li><strong>RolUsuario<\/strong><\/li>\n\n\n\n<li><strong>Factura_Producto<\/strong> (en el modelo f\u00edsico, para manejar la relaci\u00f3n de muchos a muchos entre Factura y Producto).<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">1. Preparando el entorno<\/h2>\n\n\n\n<p>Antes de empezar:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Verifica que tienes instalado <strong>Erwin Data Modeler<\/strong> con el driver de <strong>Teradata<\/strong> configurado.<\/li>\n\n\n\n<li>Crea un nuevo <strong>modelo l\u00f3gico\/f\u00edsico (LDM\/PDM)<\/strong> seleccionando <em>Teradata<\/em> como base de datos objetivo.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">2. Dise\u00f1o del modelo l\u00f3gico<\/h2>\n\n\n\n<p>En el nivel l\u00f3gico, identificamos las entidades principales y sus atributos:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Entidad <strong>Cliente<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>IdCliente (PK)<\/li>\n\n\n\n<li>Nombre<\/li>\n\n\n\n<li>Apellido<\/li>\n\n\n\n<li>Direccion<\/li>\n\n\n\n<li>Tel\u00e9fono<\/li>\n\n\n\n<li>DNI<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Entidad <strong>Factura<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>IdFactura (PK)<\/li>\n\n\n\n<li>Cif<\/li>\n\n\n\n<li>Fecha<\/li>\n\n\n\n<li>RazonSocial<\/li>\n\n\n\n<li>Direccion<\/li>\n\n\n\n<li>MontoTotal<\/li>\n\n\n\n<li>IdCliente (FK)<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Entidad <strong>Producto<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>IdProducto (PK)<\/li>\n\n\n\n<li>Producto<\/li>\n\n\n\n<li>PrecioCompra<\/li>\n\n\n\n<li>PrecioVenta<\/li>\n\n\n\n<li>Stock<\/li>\n\n\n\n<li>IdCategoria (FK)<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Entidad <strong>Categor\u00eda<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>IdCategoria (PK)<\/li>\n\n\n\n<li>Categoria<\/li>\n\n\n\n<li>Descripcion<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Entidad <strong>Usuario<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>IdUsuario (PK)<\/li>\n\n\n\n<li>Usuario<\/li>\n\n\n\n<li>Password<\/li>\n\n\n\n<li>Estado<\/li>\n\n\n\n<li>IdRol (FK)<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Entidad <strong>RolUsuario<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>IdRol (PK)<\/li>\n\n\n\n<li>Rol<\/li>\n<\/ul>\n\n\n\n<p><strong>Nota:<\/strong> Relaci\u00f3n <strong>Factura \u2013 Producto<\/strong> contiene una relacion muchos a muchos (una factura puede contener varios productos y un producto puede estar en varias facturas).<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">3. Normalizando las relaciones<\/h2>\n\n\n\n<p>Para manejar las relaciones de muchos a muchos, se crean tablas intermedias en el <strong>modelo f\u00edsico<\/strong>:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Factura_Producto<\/strong>\n<ul class=\"wp-block-list\">\n<li>IdFactura (FK)<\/li>\n\n\n\n<li>IdProducto (FK)<\/li>\n\n\n\n<li>Cantidad<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">4. Generaci\u00f3n del modelo f\u00edsico en Teradata<\/h2>\n\n\n\n<p>En el modelo f\u00edsico, definimos los <strong>tipos de datos<\/strong> seg\u00fan Teradata. Por ejemplo:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>INTEGER<\/code> para claves primarias.<\/li>\n\n\n\n<li><code>VARCHAR(100)<\/code> para nombres y correos.<\/li>\n\n\n\n<li><code>DECIMAL(10,2)<\/code> para montos y precios.<\/li>\n\n\n\n<li><code>DATE<\/code> para fechas.<\/li>\n<\/ul>\n\n\n\n<p><strong>Video Tutorial:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"4. Erwin Data Modeler - Crear Un Modelo\" width=\"640\" height=\"360\" src=\"https:\/\/www.youtube.com\/embed\/S6b2Q75gKA4?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">5. Validaciones finales<\/h2>\n\n\n\n<p>Antes de exportar el modelo a Teradata:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Verifica consistencia de nombres.<\/li>\n\n\n\n<li>Revisa que todas las relaciones tengan sus llaves correctamente asignadas.<\/li>\n\n\n\n<li>Comprueba que los tipos de datos sean compatibles con Teradata.<\/li>\n\n\n\n<li>Documenta cada entidad y columna para facilitar el mantenimiento.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">6. Exportando a Teradata<\/h2>\n\n\n\n<p>Una vez terminado el modelo f\u00edsico, Erwin permite generar el <strong>DDL de Teradata<\/strong>:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Ve a <strong>Forward Engineer > Generate Database Script<\/strong>.<\/li>\n\n\n\n<li>Selecciona Teradata como destino.<\/li>\n\n\n\n<li>Elige las tablas y relaciones que quieras generar.<\/li>\n\n\n\n<li>Exporta el script y ejec\u00fatalo en tu base de datos Teradata.<\/li>\n<\/ol>\n\n\n\n<p>Ejemplo de definici\u00f3n en el <strong>DDL para Teradata<\/strong>:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>CREATE TABLE MiBaseDatos.Cliente (\n    IdCliente INTEGER NOT NULL,\n    Nombre VARCHAR(100),\n    Apellido VARCHAR(100),\n    Direccion VARCHAR(100),\n    Telefono VARCHAR(20),\n    Dni VARCHAR(20),\n    PRIMARY KEY (IdCliente)\n);\n\nCREATE TABLE MiBaseDatos.Factura (\n    IdFactura INTEGER NOT NULL,\n    Cif VARCHAR(20),\n    Fecha DATE,\n    MontoTotal DECIMAL(10,2),\n    RazonSocial VARCHAR(20),\n    IdCliente INTEGER,\n    PRIMARY KEY (IdFactura),\n    FOREIGN KEY (IdCliente) REFERENCES Cliente(IdCliente)\n);\n\nCREATE TABLE MiBaseDatos.Producto (\n    IdProducto INTEGER NOT NULL,\n    Producto VARCHAR(100),\n    PrecioCompra DECIMAL(10,2),\n    PrecioVenta DECIMAL(10,2),\n    Stock VARCHAR(100),\n    IdCategoria INTEGER,\n    PRIMARY KEY (IdProducto),\n    FOREIGN KEY (IdCategoria) REFERENCES Categoria(IdCategoria)\n);\n\nCREATE TABLE MiBaseDatos.Categoria (\n    IdCategoria INTEGER NOT NULL,\n    Categoria VARCHAR(100),\n    Descripcion VARCHAR(100),\n    PRIMARY KEY (IdCategoria)\n);\n\n-- Nota: Esta tabla tambien se puede llamar Detalle_Pedido\nCREATE TABLE MiBaseDatos.Factura_Producto (\n    IdFactura INTEGER,\n    IdProducto INTEGER,\n    Cantidad INTEGER,\n    PRIMARY KEY (IdFactura, IdProducto),\n    FOREIGN KEY (IdFactura) REFERENCES Factura(IdFactura),\n    FOREIGN KEY (IdProducto) REFERENCES Producto(IdProducto)\n);\n\nCREATE TABLE MiBaseDatos.Usuario (\n    IdUsuario INTEGER NOT NULL,\n    NombreUsuario VARCHAR(50),\n    Contrasena VARCHAR(100),\n    Email VARCHAR(100),\n    PRIMARY KEY (IdUsuario)\n);\n\nCREATE TABLE MiBaseDatos.RolUsuario (\n    IdRol INTEGER NOT NULL,\n    Rol VARCHAR(50),\n    PRIMARY KEY (IdRol)\n);<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #D8DEE9\">CREATE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">TABLE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">MiBaseDatos<\/span><span style=\"color: #ECEFF4\">.<\/span><span style=\"color: #88C0D0\">Cliente<\/span><span style=\"color: #D8DEE9FF\"> (<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">IdCliente<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">INTEGER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">NOT<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">NULL<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">Nombre<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">VARCHAR<\/span><span style=\"color: #D8DEE9FF\">(<\/span><span style=\"color: #B48EAD\">100<\/span><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">Apellido<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">VARCHAR<\/span><span style=\"color: #D8DEE9FF\">(<\/span><span style=\"color: #B48EAD\">100<\/span><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">Direccion<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">VARCHAR<\/span><span style=\"color: #D8DEE9FF\">(<\/span><span style=\"color: #B48EAD\">100<\/span><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">Telefono<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">VARCHAR<\/span><span style=\"color: #D8DEE9FF\">(<\/span><span style=\"color: #B48EAD\">20<\/span><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">Dni<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">VARCHAR<\/span><span style=\"color: #D8DEE9FF\">(<\/span><span style=\"color: #B48EAD\">20<\/span><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">PRIMARY<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">KEY<\/span><span style=\"color: #D8DEE9FF\"> (<\/span><span style=\"color: #D8DEE9\">IdCliente<\/span><span style=\"color: #D8DEE9FF\">)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #81A1C1\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9\">CREATE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">TABLE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">MiBaseDatos<\/span><span style=\"color: #ECEFF4\">.<\/span><span style=\"color: #88C0D0\">Factura<\/span><span style=\"color: #D8DEE9FF\"> (<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">IdFactura<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">INTEGER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">NOT<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">NULL<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">Cif<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">VARCHAR<\/span><span style=\"color: #D8DEE9FF\">(<\/span><span style=\"color: #B48EAD\">20<\/span><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">Fecha<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">DATE<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">MontoTotal<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">DECIMAL<\/span><span style=\"color: #D8DEE9FF\">(<\/span><span style=\"color: #B48EAD\">10<\/span><span style=\"color: #ECEFF4\">,<\/span><span style=\"color: #B48EAD\">2<\/span><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">RazonSocial<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">VARCHAR<\/span><span style=\"color: #D8DEE9FF\">(<\/span><span style=\"color: #B48EAD\">20<\/span><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">IdCliente<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">INTEGER<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">PRIMARY<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">KEY<\/span><span style=\"color: #D8DEE9FF\"> (<\/span><span style=\"color: #D8DEE9\">IdFactura<\/span><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">FOREIGN<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">KEY<\/span><span style=\"color: #D8DEE9FF\"> (<\/span><span style=\"color: #D8DEE9\">IdCliente<\/span><span style=\"color: #D8DEE9FF\">) <\/span><span style=\"color: #D8DEE9\">REFERENCES<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">Cliente<\/span><span style=\"color: #D8DEE9FF\">(<\/span><span style=\"color: #D8DEE9\">IdCliente<\/span><span style=\"color: #D8DEE9FF\">)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #81A1C1\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9\">CREATE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">TABLE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">MiBaseDatos<\/span><span style=\"color: #ECEFF4\">.<\/span><span style=\"color: #88C0D0\">Producto<\/span><span style=\"color: #D8DEE9FF\"> (<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">IdProducto<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">INTEGER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">NOT<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">NULL<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">Producto<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">VARCHAR<\/span><span style=\"color: #D8DEE9FF\">(<\/span><span style=\"color: #B48EAD\">100<\/span><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">PrecioCompra<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">DECIMAL<\/span><span style=\"color: #D8DEE9FF\">(<\/span><span style=\"color: #B48EAD\">10<\/span><span style=\"color: #ECEFF4\">,<\/span><span style=\"color: #B48EAD\">2<\/span><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">PrecioVenta<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">DECIMAL<\/span><span style=\"color: #D8DEE9FF\">(<\/span><span style=\"color: #B48EAD\">10<\/span><span style=\"color: #ECEFF4\">,<\/span><span style=\"color: #B48EAD\">2<\/span><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">Stock<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">VARCHAR<\/span><span style=\"color: #D8DEE9FF\">(<\/span><span style=\"color: #B48EAD\">100<\/span><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">IdCategoria<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">INTEGER<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">PRIMARY<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">KEY<\/span><span style=\"color: #D8DEE9FF\"> (<\/span><span style=\"color: #D8DEE9\">IdProducto<\/span><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">FOREIGN<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">KEY<\/span><span style=\"color: #D8DEE9FF\"> (<\/span><span style=\"color: #D8DEE9\">IdCategoria<\/span><span style=\"color: #D8DEE9FF\">) <\/span><span style=\"color: #D8DEE9\">REFERENCES<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">Categoria<\/span><span style=\"color: #D8DEE9FF\">(<\/span><span style=\"color: #D8DEE9\">IdCategoria<\/span><span style=\"color: #D8DEE9FF\">)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #81A1C1\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9\">CREATE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">TABLE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">MiBaseDatos<\/span><span style=\"color: #ECEFF4\">.<\/span><span style=\"color: #88C0D0\">Categoria<\/span><span style=\"color: #D8DEE9FF\"> (<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">IdCategoria<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">INTEGER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">NOT<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">NULL<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">Categoria<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">VARCHAR<\/span><span style=\"color: #D8DEE9FF\">(<\/span><span style=\"color: #B48EAD\">100<\/span><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">Descripcion<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">VARCHAR<\/span><span style=\"color: #D8DEE9FF\">(<\/span><span style=\"color: #B48EAD\">100<\/span><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">PRIMARY<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">KEY<\/span><span style=\"color: #D8DEE9FF\"> (<\/span><span style=\"color: #D8DEE9\">IdCategoria<\/span><span style=\"color: #D8DEE9FF\">)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #81A1C1\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">--<\/span><span style=\"color: #D8DEE9FF\"> Nota<\/span><span style=\"color: #ECEFF4\">:<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">Esta<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">tabla<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">tambien<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">se<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">puede<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">llamar<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">Detalle_Pedido<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9\">CREATE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">TABLE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">MiBaseDatos<\/span><span style=\"color: #ECEFF4\">.<\/span><span style=\"color: #88C0D0\">Factura_Producto<\/span><span style=\"color: #D8DEE9FF\"> (<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">IdFactura<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">INTEGER<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">IdProducto<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">INTEGER<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">Cantidad<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">INTEGER<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">PRIMARY<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">KEY<\/span><span style=\"color: #D8DEE9FF\"> (<\/span><span style=\"color: #D8DEE9\">IdFactura<\/span><span style=\"color: #ECEFF4\">,<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">IdProducto<\/span><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">FOREIGN<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">KEY<\/span><span style=\"color: #D8DEE9FF\"> (<\/span><span style=\"color: #D8DEE9\">IdFactura<\/span><span style=\"color: #D8DEE9FF\">) <\/span><span style=\"color: #D8DEE9\">REFERENCES<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">Factura<\/span><span style=\"color: #D8DEE9FF\">(<\/span><span style=\"color: #D8DEE9\">IdFactura<\/span><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">FOREIGN<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">KEY<\/span><span style=\"color: #D8DEE9FF\"> (<\/span><span style=\"color: #D8DEE9\">IdProducto<\/span><span style=\"color: #D8DEE9FF\">) <\/span><span style=\"color: #D8DEE9\">REFERENCES<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">Producto<\/span><span style=\"color: #D8DEE9FF\">(<\/span><span style=\"color: #D8DEE9\">IdProducto<\/span><span style=\"color: #D8DEE9FF\">)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #81A1C1\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9\">CREATE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">TABLE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">MiBaseDatos<\/span><span style=\"color: #ECEFF4\">.<\/span><span style=\"color: #88C0D0\">Usuario<\/span><span style=\"color: #D8DEE9FF\"> (<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">IdUsuario<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">INTEGER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">NOT<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">NULL<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">NombreUsuario<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">VARCHAR<\/span><span style=\"color: #D8DEE9FF\">(<\/span><span style=\"color: #B48EAD\">50<\/span><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">Contrasena<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">VARCHAR<\/span><span style=\"color: #D8DEE9FF\">(<\/span><span style=\"color: #B48EAD\">100<\/span><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">Email<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">VARCHAR<\/span><span style=\"color: #D8DEE9FF\">(<\/span><span style=\"color: #B48EAD\">100<\/span><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">PRIMARY<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">KEY<\/span><span style=\"color: #D8DEE9FF\"> (<\/span><span style=\"color: #D8DEE9\">IdUsuario<\/span><span style=\"color: #D8DEE9FF\">)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #81A1C1\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9\">CREATE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">TABLE<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">MiBaseDatos<\/span><span style=\"color: #ECEFF4\">.<\/span><span style=\"color: #88C0D0\">RolUsuario<\/span><span style=\"color: #D8DEE9FF\"> (<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">IdRol<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">INTEGER<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">NOT<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">NULL<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">Rol<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">VARCHAR<\/span><span style=\"color: #D8DEE9FF\">(<\/span><span style=\"color: #B48EAD\">50<\/span><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #ECEFF4\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">    <\/span><span style=\"color: #D8DEE9\">PRIMARY<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #88C0D0\">KEY<\/span><span style=\"color: #D8DEE9FF\"> (<\/span><span style=\"color: #D8DEE9\">IdRol<\/span><span style=\"color: #D8DEE9FF\">)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D8DEE9FF\">)<\/span><span style=\"color: #81A1C1\">;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusi\u00f3n<\/h2>\n\n\n\n<p>Crear un modelo de datos en <strong>Erwin Data Modeler<\/strong> para Teradata no solo ayuda a organizar la informaci\u00f3n, sino que tambi\u00e9n asegura consistencia, escalabilidad y documentaci\u00f3n clara. Con este modelo, puedes gestionar clientes, facturas, productos, categor\u00edas y usuarios de manera eficiente, y tener un dise\u00f1o listo para producci\u00f3n en Teradata.<\/p>\n\n\n\n<p><strong>Nota:<\/strong> en este caso se utilizo como base de datos Teradata, pero usando la misma metodolo\u00eda se puede hacer lo mismo para llevarlo a SqlServer, Oracle o el motor de bases de datos de su preferencia.<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Creando un modelo en Erwin Data Modeler con base de datos Teradata En este art\u00edculo vamos a recorrer paso a paso c\u00f3mo crear un modelo en Erwin Data Modeler utilizando como motor de base de datos Teradata. Tomaremos como ejemplo un conjunto de entidades comunes en un escenario de negocio: 1. Preparando el entorno Antes [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":2727,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[61],"tags":[],"class_list":["post-2719","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-teradata"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/blog.daiconext.com\/index.php\/wp-json\/wp\/v2\/posts\/2719","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.daiconext.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.daiconext.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.daiconext.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.daiconext.com\/index.php\/wp-json\/wp\/v2\/comments?post=2719"}],"version-history":[{"count":7,"href":"https:\/\/blog.daiconext.com\/index.php\/wp-json\/wp\/v2\/posts\/2719\/revisions"}],"predecessor-version":[{"id":2736,"href":"https:\/\/blog.daiconext.com\/index.php\/wp-json\/wp\/v2\/posts\/2719\/revisions\/2736"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.daiconext.com\/index.php\/wp-json\/wp\/v2\/media\/2727"}],"wp:attachment":[{"href":"https:\/\/blog.daiconext.com\/index.php\/wp-json\/wp\/v2\/media?parent=2719"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.daiconext.com\/index.php\/wp-json\/wp\/v2\/categories?post=2719"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.daiconext.com\/index.php\/wp-json\/wp\/v2\/tags?post=2719"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}