142 How to use lookup transformation with cache file in ssis

Поделиться
HTML-код
  • Опубликовано: 31 янв 2025

Комментарии • 4

  • @jayakumarjk123
    @jayakumarjk123 2 года назад

    hii aquil when i use lookup transform in incremental load with 2 million records its taking more than 6 hours of time and i do have another table with 10 million records is there any faster way to perform incrimental load without using lookup

    • @learnssis
      @learnssis  2 года назад

      Try to use SQL Joins between the 2 tables and get the matched and unmatched records, it will be faster as compare to Lookup transformation in SSIS.

  • @JAE-gg1xb
    @JAE-gg1xb 2 года назад

    Hello Sir do you do Videos For SSRS too?

    • @learnssis
      @learnssis  2 года назад +1

      As of now I have not made any video on SSRS.