Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

LookUp

Hi all, I have ContID in Dim table and I have ContID in Fact table, I want to get only those ContID's in dim table into fact table Instead of Inner Join on ContID's from two tables I weanna do...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Might be, I have doubt on this

I just want to filter Id's in 2nd table for the id's which are present in 1st table

AmiraBedh's avatar
AmiraBedh
Icon for Super User rankSuper User
3 years ago

Can you please provide more details?
I already provided an answer.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi,
    Actually in SQL lvel I was doing Inner Join based on ID  IN fact on dim table, it's giving lot of refreshing issue
    data size is like 38M, so it's taking 3.5hrs to refresh
    So I need alternate sol for that

    • AmiraBedh's avatar
      AmiraBedh
      Icon for Super User rankSuper User
      3 years ago

      Can you please provide sample data ?