Look up for different files

ani_chutti@yahoo.co.in · Tue Jul 28, 2015 4:04 am

Dear All,

I have 5 seq files which has country and some other data. Every file will come at different timings and there is no std time for each. I have a reference table for country code.

Goal is: Load the data into target table and load the country code using lookup. There is no choice for multiple job design. All these has to be designed in one single job

rkashyap · Post by **rkashyap** » Tue Jul 28, 2015 6:02 am

What is the problem that you are facing?

ray.wurlod · Post by **ray.wurlod** » Tue Jul 28, 2015 6:10 am

ani_chutti@yahoo.co.in wrote:There is no choice for multiple job design. All these has to be designed in one single job

Why?

Resist stupid requirements! Or is it an interview question?

ani_chutti@yahoo.co.in · Wed Jul 29, 2015 11:09 pm

Yup. This is the interview question. Question is to come up with single job seq for 5 seq files which are loading in different timelines

ray.wurlod · Post by **ray.wurlod** » Thu Jul 30, 2015 1:29 am

A single job sequence is not the same thing as a single job.

But you can nevertheless examine the possibility of having that sequence, after determining which file is next to be processed, invoking a generic job to process it then moving the file to a "done" location.

Rinse and repeat or sleep.

DSXchange

Look up for different files

Look up for different files

Re: Look up for different files

Re: Look up for different files