ETL, Data Integration and Data Interchange mind maps
40 mind maps by 24 users
This GoConqr page gathers over 30 mind maps on ETL transformations and data interchange, including lookup queries, XML and JSON. University students and professional candidates can use them to study these topics, and teachers can find material for lessons; some maps also suit school students. Choose a map to explore.
Mind maps
-
115 nodesFinal One Data Interface · Data Structures · Data Specification · Digital Methods of Ex...
-
71 nodesLookup trans Passive · Active · Connected · Unconnected · source types · source
-
45 nodesJOINER Transformation Overview · Master and Detail · ACTIVE · limitations
-
129 nodesData Exchange Methods/Systems Data Interface · Data Structures · Data Specifications · Methods of Data Exchange
-
27 nodesTransaction Control Transformation active · connected · lets you control comm... · A transaction is the ... · within a mapping: tra... · If you have a flat fi...
-
43 nodesExisting Data Exchanges JSON · XML · SOAP · Messaging · GraphQL · SQL
-
50 nodesHTTP Trans Passive · Connected · HTTP transformation e... · Connecting to HTTP se... · Built using Custom Tr... · Configuration
-
30 nodesJSON Overview What is it? · Data Interface · Data structures · Data specifications
-
49 nodesLookup query Default query · Overriding · Filtering source rows
-
33 nodesStored Procedure Trans Passive · Connected · to populate and maint... · 3 types of data that ... · Unconnected · When is it run
-
40 nodesjoiner active · conected · matches 1 or more pai... · limitations · caching · join condition
-
43 nodesXML & XML Schema What is XML? · Document Object Model... · XML Namespaces · XML Schema
-
12 nodes1_JOINER Transformation - Transaction Scope Property Transaction Scope Pro... · ACTIVE
-
50 nodesMind Map Data Interface · Data Structures · Data Specifications · Digital methods of ex...
-
33 nodesXPath Predicates 谓语: writte... · Expressions · Node Types · Axes
-
17 nodesUNION Transformation ACTIVE · merge data from multi... · like UNION ALL · does not remove dupli... · reads all sources con... · pushes blocks of data...
-
11 nodesExpression Transformation calculate value in a ... · PASSIVE · test conditional stat... · perform non-aggregate... · create in Transformat... · Port: input, output, ...
-
9 nodesSQL Override Properties TAB · Do not change the por... · SQL Query overrides t... · enclose all database ... · Can override at the s...
-
86 nodesInformatica MDM Hub Store · Base object · Queries and Packages · Timeline · Hub Processes Data Flow
-
77 nodesJSON API Data Knowledge Data Interface · Data Structures · Data Specifications
-
29 nodesDHS CCITS - All data Subscribed @ Level1 for All enternity (Will there be a level difference?) Notification to DSS o... · Notification to DSS w... · Tier 2 Staff needs to... · Service Provider
-
50 nodesMind map Data Interface · Data Structures · Data Specification
-
26 nodesTypes of Business Writing (Data Analytics) Transactional · Instructional · Analytical · Persuasive · Descriptive
-
27 nodesBODS with ECC(Data Transfers) RFC · Shared Directory · Custom Transfer · FTP · Direct Download
-
37 nodesSAP Interfaces to BODS SAP Master Data Services · SAP NetWeaver BW · SAP NetWeaver BW Open... · SAP Application DataS...
-
28 nodesUPDATE STRATEGY Transformation ACTIVE · Setting Update Strategy · controls how rows are... · Aggregator before Upd... · Lookup and Update Str...
-
60 nodesPart 1 JSON vs XML · Task and Context · Data specification · Data structure · Developer environment
-
33 nodesNew date added to base tables New data gets added t...
-
43 nodesETL PHASE EXTRACTION · TRANSFORMATION · LOADING
-
18 nodesAGGREGATOR ACTIVE · COMPONENTS · Aggregate Expression · calculations on groups · conditional clauses t... · Incremental Aggregati...
-
25 nodesJSON Data Interface · Data Structures · Data Specification
-
28 nodesLookup condition like a WHERE clause · Data types must match · must have · multiple conditions · Optimize order · matches NULL values
-
39 nodesJSON/API Data interface · Data structures · Data specifications
-
10 nodesSTORED PROCEDURE Transformation used to maintain and ... · 3 types of data that ... · PASSIVE · Connected or Unconnected
-
9 nodesFILTER Transformation ACTIVE · Filter Condition · use early in mapping;...
-
21 nodes(swapi.tech) Star War API Data Interface · Data Structures · Data Specifications
-
7 nodesETL Functions Transform · Extract · Load
-
9 nodesFilter Trans Active · connected · allows rows that meet... · FILTER conditions · NULL, treated as FALSE.
-
22 nodesData Exchange Systems Data Structure · Data Interface · Data Specifications · Digital Methods of Ex...
-
5 nodesScript Components Does not support erro... · Transformation (1 inp... · Source (Multiple outp... · Destination (1 input)
More ETL, Data Integration and Data Interchange resources
About etl, data integration and data interchange mind maps
GoConqr OriginalETL, Data Integration and Data Interchange mind maps
These community-made maps offer different entry points into the unit. Lookup query sets out details of the default query and column order, while Expression Transformation covers calculations within a single row. Transaction Control Transformation focuses on commit and rollback transactions.
For data interchange, the listing includes JSON Overview, XML & XML Schema and XPath. The XPath map gives examples of symbols used to select nodes and attributes.
Study with a map
Start with Lookup query if you want to focus on a specific query, or XPath if you are studying node selection. Follow the branches and explain each point in your own words. Return to the map when a detail needs another look.
If you prefer running text, switch to the notes on the unit page. Pick a map that matches the topic you are studying.
Frequently asked questions
Which mind map should I start with?
Start with Lookup query if you want to study default queries and column order. For data interchange, XPath offers a focused look at symbols used to select nodes and attributes. Both give you a specific topic to follow through a map.
What topics do these mind maps cover?
The maps cover lookup queries, SQL overrides and transformations, including expression, joiner and transaction control. The listing also includes maps on XML, XPath, JSON and data exchange systems. You can choose a map according to the topic you are studying.
Are the mind maps free to use?
Yes. Every resource listed on this page is free to open and study without an account. The maps were made by GoConqr users, so they offer community-created ways to explore the topics listed here, from transformations to data interchange.
Who are these maps for?
The listing is mainly suited to university students and professional candidates studying ETL and data interchange. Teachers can also use the maps as material for lessons, and some maps suit school students. The topics range from individual transformations to XML and JSON.