Questions tagged [mapping]

Corresponding every element of a given set to a unique element of another set or it may refer to a process of creating data element mappings between two distinct data models (objects)

In this context, mapping refers to the process of creating data element mappings between two distinct data models (objects).

When it refers to mapping in data integration, it is a set of source and target definitions linked by the transformation objects that define the rules for data transformation. Mappings represent the data flow between sources and targets.

Data mapping is typically used as a first step for a wide variety of data integration tasks such as:

  1. Data transformation or data mediation between a data source and a destination

  2. Identification of data relationships as part of data lineage analysis

  3. Replication of data between two entities with different key-value assignments

  4. Discovery of hidden sensitive data such as the last four digits social security number hidden in another user id as part of a data masking or de-identification project

  5. Consolidation of multiple databases into a single data base and identifying redundant columns of data for consolidation or elimination.

9739 questions
18
votes
3 answers

Postgres: user mapping not found for "postgres"

I'm connected to schema apm. Trying to execute a function and getting below error: ERROR: user mapping not found for "postgres" Database connection info says: apm on postgres@PostgreSQL 9.6 psql version: PostgreSQL 9.6.3, compiled by Visual C++…
Vikram
  • 347
  • 1
  • 3
  • 8
18
votes
2 answers

How to update the mapping in Elasticsearch to change the field datatype and change the type of analyzers in string

While trying to update the mapping I get the following error: {"error":{"root_cause":[{"type":"illegal_argument_exception","reason":"mapper [timestamp] of different type, current_type [string], merged_type…
PRIYANSHU BAJPAI
  • 325
  • 1
  • 4
  • 11
18
votes
2 answers

R: Maps with Time Slider?

Is there a way to implement a time slider for Leaflet or any other interactive map library in R? I have data arranged in a time series, and would like to integrate that into a "motion" map where the plot points change dynamically over time. I was…
Riley Hun
  • 2,541
  • 5
  • 31
  • 77
18
votes
3 answers

Proper Hibernate id generator for postgres serial/bigserial column?

My PostgreSQL tables have id's of type bigserial, meaning they are generated at the time rows are inserted (and thus, the id column's value is not supplied in the INSERT statement). I'm having difficulty finding the proper value for the
Matt Huggins
  • 81,398
  • 36
  • 149
  • 218
18
votes
5 answers

Foreign key not stored in child entity (one-to-many)

I'm quite new to hibernate and have stumbled on this problem, which I can't find solution for. When persisting parent object (with one-to-many relationship with child), the foreign-key to this parent is not stored in child's table. My…
Kamil Łoś
  • 218
  • 1
  • 2
  • 6
18
votes
5 answers

illegal access to loading collection error

I'm getting the error Illegal access to loading collection when I'm trying to get a list of variants belonging to a certain product. The NHibernate mapping is as below
Rob
  • 6,731
  • 12
  • 52
  • 90
18
votes
1 answer

Knockout.js mapping a JSON into an observable-array

I want to build a client for my REST-Service using Knockout.js. I have a lot of Repositorys i want to access through different urls - so i came up with this solution using the Revealing-Prototype-Pattern. My problem: I can not find out how to map…
Thomas Deutsch
  • 2,344
  • 2
  • 27
  • 36
17
votes
4 answers

MySQL: Understanding mapping tables

When building a category navigation system for a business directory with a many to many relationship, I understand that it is good practise to create a mapping table. Category Table ( CategoryId, CategoryName ) Business Table ( BusinessId,…
Richard Bell
  • 405
  • 3
  • 7
  • 21
17
votes
2 answers

Solidity, Solc Error: Struct containing a (nested) mapping cannot be constructed

I am using Solc version 0.7.0 installed by npm. When I try to create a Struct that contains mapping, I received an error: "Struct containing a (nested) mapping cannot be constructed." Please check the code: // SPDX-License-Identifier: MIT pragma…
coding
  • 627
  • 7
  • 20
17
votes
2 answers

EF4 code-first: defining object relationships, foreign keys

< RANT_MODE > EF code-first approach is meant to save lots of time but for the time being I've only seen toy examples and spent hours trying to understand how I can make it generate the db I want. But still hoping that Eureka moment :-) < RANT_MODE…
Dav
  • 1,102
  • 3
  • 10
  • 22
17
votes
3 answers

Automapper creating new instance rather than map properties

This is a long one. So, I have a model and a viewmodel that I'm updating from an AJAX request. Web API controller receives the viewmodel, which I then update the existing model using AutoMapper like below: private User updateUser(UserViewModel…
Ron Brogan
  • 892
  • 1
  • 9
  • 25
17
votes
3 answers

Automapper custom many-to-one conversion

Automapper Many To One conversion How to convert values of many properties from the source object to a single type in destination object? Can I use in this case Value Resolvers? Or maybe there is better solution? Documentation Here is example from…
Pawel Maga
  • 5,428
  • 3
  • 38
  • 62
17
votes
1 answer

Fluent Nhibernate Many-to-Many mapping with extra column

I want to map sth like this using fluent Nhibernate but I am not sure how to map the inventory table This is the tables I have : Product (Id,Name, ...) Warehouse(Id, Name, ...) Inventory(Product_id, Warehouse_id, StockInHand) and Mappings like…
pang
  • 3,964
  • 8
  • 36
  • 42
17
votes
6 answers

Storing Python dictionary entries in the order they are pushed

A Python dictionary is stored in no particular order (mappings have no order), e.g. >>> myDict = {'first':'uno','second':'dos','third':'tres'} myDict = {'first':'uno','second':'dos','third':'tres'} >>> myDict myDict {'second': 'dos', 'third':…
Escualo
  • 40,844
  • 23
  • 87
  • 135
17
votes
2 answers