What is the difference between filter and lookup transformation?



What is the difference between filter and lookup transformation?..

Answer / Nitin Kumar Sinha

Filter transformation is used to select specific rows from a table based on certain conditions, while Lookup transformation is used to combine data from multiple tables by matching values in one table with corresponding values in another table.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Data Warehouse General Interview Questions

what is difference between scd2 and scd3

3 Answers  


Compare cold fusion with other programming languages?

1 Answers  


What a static and local variable?

1 Answers  


What is degenerate dimension table?

1 Answers  


How to import vsam files from source to target. Do we need a special plugin?

1 Answers  


Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?

1 Answers  


What is the purpose of cluster analysis in data warehousing?

1 Answers  


What is a data warehousing?

1 Answers  


What are the advantages of cold fusion?

1 Answers  


In general, how many Fact & Dimension tables are present in a Banking Data warehouse project ?

1 Answers  


What are various warehousing tools?

1 Answers  


What is the difference between agglomerative and divisive hierarchical clustering?

1 Answers  


Categories