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.
Illustrates the term heap in data structures?
Illustrates the term natural key in Sybase?
Give a brief introduction of the term ‘SQL Server 2005 Analysis Services’ (or SSAS)?
Describe in brief some of the criticism regarding Sybase IQ?
Explain the automated document scheduling and distribution?
Provide a brief introduction of the term slowly changing dimensions (or SCD)?
Describe briefly the term data warehouse?
Explain the connected and unconnected transformation?
Illustrates the about Data Manipulation Language?
Illustrates the benefits of running stored procedure upon a database engine?
18,76,764
1956262 Asked
3,689
Active Tutors
1426582
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!