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.
Assume when a session fails subsequent to loading of 10,000 records in to target. How can we load the records from 10001 the record when we run session next time?
Elucidate what are the tasks which Load manger process will do?
Briefly describe the ETL procedure in data warehousing?
Describe briefly the alternative terminology which is employed in the relational model?
Explain briefly the term Web Services?
What understand by the term SQL, and give its importance?
Illustrate the five SQL built-in functions.
MiniSQL Parser Relax; you don't have to write the parser! On the contrary, a complete parser and type checker for the MiniSQL language is provided with the skeleton code. This small subset of SQL includes the
Illustrate the term data mart. What do you mean by it?
Explain about the stored-procedures and its advantages.
18,76,764
1936724 Asked
3,689
Active Tutors
1413090
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!