on 08-25-2016 5:06 PM
Hi All,
I have 5 flat files as source with same stature, I want to load the data into single target table. My requirement is I want see each file count in my target.
Thanks
Murali
Hi Murali,
In the data flow click on the flat file which will open the properties, on the bottom will be the Source Information. Give Yes in Include File name column option.
After merging all the five source files you can use function gen_row_num_by_group(QT_Merge.DI_FILENAME), then take the max value against the filenames.
Regards,
Senthil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.