ETL, Data Integration and Data Interchange notes
12 notes by 4 users
This page gathers a small set of user-made notes on ETL, Data Integration and Data Interchange, covering lookup ports, queries and transformations. They support university students and professional candidates practicing technical concepts, as well as teachers preparing material; some resources also suit school students. Explore the notes and choose a topic to study.
Notes
-
Transaction Control Transformation - created from Mind Map active connected lets you control commit and roll back transactions based on a set of rows that pass through
-
Lookup query - created from Mind Map_1 Default query SELECT ORDER BY All lookup ports Can generate sql Don't change ports/columns orders the columns by the same order they appear in the lookup IS generates the order by you can't see this when you generate ...
-
Mappings in Informatica: Create, Components, Parameter, Variable Mapping - Mapping is a collection of source and target objects linked together by a set of transformations. Source Definition - Defines the structure and characteristics of the source. Transformation - Defines h...
-
Stored Procedure Trans - created from Mind Map Passive Connected to populate and maintain databases
-
Lookup Ports - created from Mind Map connected port type I o L Input port. Create an input port for each lookup port you want to use in the lookup condition. You must have at least one input or input/output port in each Lookup transformation. Output port...
-
HTTP Trans - created from Mind Map_1 Passive Connected HTTP transformation enables you to connect to an HTTP server to use its services and applications. When you run a session with an HTTP transformation, the IS connects to the HTTP server and issues a ...
-
Data Source - created from Mind Map M4V Migration DB CBO MI
-
Untitled Facts: Data filter: limit or qualify data pulled from the source (part of WHERE clause), Two Types: Simple and Advanced. Simple - when all criteria can be joined with AND (meets all criteria) and is NOT a flat file. A...
-
Lookup condition - created from Mind Map like a WHERE clause Data types must match must have
-
SQL Override - created from Mind Map Properties TABSql Query Do not change the ports or the port order SQL Query overrides the User-Defined Join, Source Filter, Number of Sorted Ports, and Select Distinct
-
Returning multiple rows - created from Mind Map Lookup policy on multiple match is Use All Valuesproperty becomes read only can cacheall rows for a lookup key by key index can configure SQL override
-
Lookup Cache - created from Mind Map persistant pre-built lookup dynamic flat file relational
More ETL, Data Integration and Data Interchange resources
About etl, data integration and data interchange notes
GoConqr OriginalWhat the ETL, Data Integration and Data Interchange notes cover
These notes focus on specific parts of data integration work. They cover lookup ports, conditions, queries and caches, alongside mappings in Informatica. Other notes describe stored procedure, transaction control and HTTP transformations, as well as SQL overrides and a data source.
How to study with the notes
Start with the notes on lookup ports if you want to follow how ports are used in a lookup condition. Then read the notes on lookup conditions and queries to connect the port types with the conditions and query structure. The cache notes offer a further topic to explore.
As you read, write down the purpose of each component and compare it with the next one. For a different view, switch to a mind map on the unit page. When you want to check your recall, try a unit quiz. Choose a note and follow the details at your own pace.
Frequently asked questions
Which notes are a good starting point?
The notes on lookup ports are a useful starting point if you want to understand how ports relate to lookup conditions. From there, the notes on lookup conditions and queries cover related details, including matching data types and the structure of a default query.
Are these notes free to use?
Yes. Every note listed here is free to open and study without an account. The notes were made by GoConqr users, not by GoConqr. A free account also lets you save quiz scores and make your own quizzes, mind maps, flashcards and notes.
Who are these notes for?
Most of the material suits university students and professional candidates studying data integration concepts and tools. Teachers can use the notes when preparing material, and some resources are suited to school students. The topics range from lookup ports and caches to mappings and transformations.