Connect Jobs - 2 quick questions
Hello!
I am wondering 2 'quick' things:
1. Is there a limit to how many files a Connect Job can pick up in 1 run? I have a situation where many files need to be imported based on a naming convention. Right now there are 43 files and the CJ picks them all up. But we might end up having hundreds of files. I just need to know if there is a 'choking point' number.
2. If I use the trunc and load ("Remove all existing records") in a Supp table import, does 1 CJ remove all records only when it starts the job? Ex. if I'm loading the 43 files in the same CJ, will I end up with a supp table of all 43 files or will it trunc and load each file and end up with only the 43rd file in my table?
0