I need some help related to R programming. It would be really nice if someone could help me. I am a beginner in R language.
I have one FACT table in SQL Server database, which will have around 10 million records. I am planning to fetch entire data through dbGetQuery and store it in a Data Table. Then perform some cleaning, create derived columns and at the end process the data.
I am little confused how should I approach this problem.
If someone has experience or have done similar thing, please let me know.
Thanks a lot