Answer Posted / murthy
generally lookup is used to search for a record.in realtime
mainly people use this to fetch the key values doing a
lookup on the other table.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Do we need an etl tool?
give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.
Explain different types of partitioning?
diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture
Can we create Hierarchies in generic datasources?
what is data modeling?
State the differences between shortcut and reusable transformation
What do you understand by the term ‘transformation’?
how to load the data to fact table?
how do u extract data from different data sources explain with an example?
Identifying the bottlenecks in various components of Informatica and resolving them.
Explain the key challenges that you face while performing etl testing.
Explain do we need an etl tool?
Difference between flat files and relational sources?
what is the difference between cardinality and Nullability?
