Guys, How do you pick up certain

[ProDev]

Guys,

How do you pick up certain flat file supplied to you (on daily basis)
for your laoding ? I mean to say that, do you delete the file X after
success full load on the same day so that your session will use the
file X (newly copied) next day ?

Pleas guide me on this.

Thanks

 

[smajay]

You need to specify the name of the file in session properties that need to be loaded into warehouse.
Once the data is loaded into warehouse successfully rename that file to .bal extension or .old. this can be done in post session script. So that it will be easy to differentiate between old and new file. You can also delete the file once the data is loaded so there is no more confusion at all.



-Ajay

 

[capreal26]

another way to do is to write a shell script to be executed before session which checks for presence of files & checks the timestamp (in the name of the input file itself).
eg: ur input file(s) for today could be :

input_file_04082003.csv --> actual input file
input_file_04082003.flg --> flag file which indicates whether file is present or not.