You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!