Lookup and filter transformation
Write down the differentiation between lookup and filter transformation?
Expert
i) Filter transformation is Active transformation as well as Lookup is a Passive transformation
ii) Filter transformation is employed to filter rows based on the condition and Lookup is employed to look up data in the flat file or relational table, synonym, or view.
Write down the brief notes on multidimensional data model.
Briefly describe the foreign key columns in dimension table and fact table?
Name the methods that are available in storing sequential files?
Specify the use of data stage designer?
Explain the function of metadata for the three-layer architecture?
Illustrate briefly the term DBMS?
Describe the differences between an extranet and an intranet.
Explain, what are Dimensional table?
How must you modify the function to handle error?
Consider a MOVIE database in which data is recorded about the movie industry. The data requirements are summarized as follows: ¦ Each movie is identified by title and year of release. Each movie has a length in minutes. Each has a production company, and each is classified under one or more genre
18,76,764
1955202 Asked
3,689
Active Tutors
1431478
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!