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.
Briefly describe the reason of synchronization function offered in Analysis Services 2005 ?
Write a short note on an ERD?
Categorize the Hashing Functions based on the different methods through which the key value is found?
Illustrates the basic elements in ER models?
Illustrate the term multimedia data mining in short.
Briefly describe the differentiation between the EXCEPT and INTERSECT operators?
Give brief introduction of the term breakpoint in SSIS?
Elucidate Where to keep informatica rejected data? How to remove the informatica rejected data?
How to produce an Auto Incremental Number within a SSIS Package?
Briefly describe the capabilities and concepts of Business Intelligence?
18,76,764
1945793 Asked
3,689
Active Tutors
1452468
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!