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.
Explain the calculation contexts?
Define the term filter?
Describes the main data structures used in following areas: RDBMS, Network data model and Hierarchical data model?
What do you understand by the term cascading update in DBMS?
What types of tables derived from the ERD?
Explain all the types of Jobs you developed?
Write about the components of the Ascential Data Stage?
Illustrates the properties of Cursors in brief?
Explain the Combined Query?
Briefly describe the new features of SQL Server 2005 Analysis Services (or SSAS)?
18,76,764
1951629 Asked
3,689
Active Tutors
1444096
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!