Lookup Transformations
10 resources created by 3 users
This Lookup Transformations page on GoConqr gathers community-made mind maps, notes, flashcards and a quiz on lookup queries, conditions, ports and caches. It is for university students and professional candidates studying lookup concepts, and teachers looking for material on these topics. The small collection spans university and professional levels, with resources that range from an overview of lookup types to questions on Informatica transformations. Start with a mind map, then try the quiz.
Top Lookup Transformations resources
-
71 nodesLookup trans Passive · Active · Connected · Unconnected · source types · source
-
15 cardsLOOKUP Transformation Lookup Transformation 1
-
49 nodesLookup query Default query · Overriding · Filtering source rows
-
3 questionsINFORMATICA QUIZ Which one is not correct about filter transformation?
-
28 nodesLookup condition like a WHERE clause · Data types must match · must have · multiple conditions · Optimize order · matches NULL values
Quizzes
Mind maps
-
71 nodesLookup trans Passive · Active · Connected · Unconnected · source types · source
-
49 nodesLookup query Default query · Overriding · Filtering source rows
-
28 nodesLookup condition like a WHERE clause · Data types must match · must have · multiple conditions · Optimize order · matches NULL values
Flashcards
Notes
-
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 ...
-
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...
-
Lookup condition - created from Mind Map like a WHERE clause Data types must match must have
-
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 topics
About Lookup Transformations
GoConqr OriginalStart with the overview
The mind map “Lookup trans” is a starting point for this collection. It brings together passive and active, connected and unconnected lookups, along with source types such as relational and flat file sources. It also mentions sorted input and describes overriding the default SQL statement to add a WHERE clause or query multiple tables.
After the overview, use the “LOOKUP Transformation” flashcards to work through terms such as relational lookup, connected lookup, lookup ports and lookup cache. The deck also covers transformation types and tasks. The notes on lookup ports offer a closer look at the input ports used in a lookup condition.
Follow the query and condition maps
The “Lookup query” mind map covers the default query, SELECT, ORDER BY and lookup ports. It describes generated SQL and the order of columns in the lookup. A related note presents the same query material in note form, giving you another way to read through it.
Next, use “Lookup condition” to study matching data types, multiple conditions and condition order. The map describes multiple conditions as being evaluated with AND and compares a lookup condition to a WHERE clause. The related condition note provides another view of these points.
Connect the resources
The notes on lookup cache cover static and dynamic caches, shared caches and recaching from the lookup source. Another note covers returning multiple rows, including a multiple-match policy and an SQL override. These resources let you focus on particular terms from the broader overview.
The quiz includes questions on lookup caches and conditions alongside other Informatica transformation questions. Work through the maps first, then use the quiz questions to identify points to revisit in the notes. Lookup Transformations is one section of ETL, Data Integration and Data Interchange in Databases and data science, so you can return to the wider unit after studying this collection. Explore a map and use the quiz to guide your next look at the notes.
Frequently asked questions
Which resource is a useful starting point?
The “Lookup trans” mind map offers an overview of lookup types and sources, making it a useful place to begin. It covers connected and unconnected lookups, relational and flat file sources, and an SQL override. The “LOOKUP Transformation” flashcards then give you a way to work through terms including lookup ports and caches.
What do the mind maps cover?
The mind maps cover lookup transformations, queries and conditions. “Lookup trans” introduces types and sources, while “Lookup query” looks at the default query, SELECT and ORDER BY. “Lookup condition” covers matching data types, multiple conditions and their order. Related notes give you another way to read about queries and conditions.
Are these resources free to use?
Yes. Every resource listed on this page is free to open and study, and the quiz is free to take, without an account. The resources were made by GoConqr users rather than GoConqr. A free account can save your quiz scores and lets you make your own quizzes, mind maps, flashcards and notes.
What does the quiz cover?
The quiz includes questions about lookup caches and conditions, as well as questions about filter transformation and designer tools. It can be used alongside the lookup maps: study the relevant terms in the maps and notes, then use the questions to see which points you want to look at again.