Select File | Description | File Pattern |
|---|---|---|
ALL | The connector selects all files in the source directory. | - |
Equals | The connector selects value that is equal to the specified file pattern. | For example, when you enter "Cloud" as the value, the connector fetches files which contain "Cloud" in the file name. |
Not Equals | The connector selects files that do not contain the specified file pattern. | For example, when you enter "Database" as the value, the connector fetches files that do not contain "Database" keyword in its name. |
File Extension | The connector selects file that has specified file name extension. | For example, when you enter "PDF" as the value, the connector fetches the PDF format files present in the source directory. |
Starts with | The connector selects file that starts with the specified name. | For example, when you enter "Informatica" as the value, the connector fetches files which begin with word "Informatica" in its name. |
Ends with | The connector selects file that ends with the specified value. | For example, when you enter "Updated" as the value, the connector fetches files that end with word "Updated" in its name. |
Contains | The connector selects file that contains the similar keyword value. | For example, when you enter "Integration" as the value, the connector fetches files that contain word "Integration" word in its name. |
FileSize Greater than | The connector selects file that are greater than the specified size. You must enter the file size value in KB. When you provide a decimal value to file Size field, the connector reads the value as zero and does not fetch files from the directory. | For example, when you enter 50 as the value, the connector fetches files with files size greater than 50 KB. |
FileSize Lesser than | The connector selects files that are smaller than the specified size. You must enter the file size value in KB. When you provide a decimal value to file Size field, the connector reads the value as zero and does fetch files from the directory. | For example, when you enter 100 as the value, the connector fetches files with file size less than 100 KB. |
FileSize Equals to | The connector selects files with specified file size value. You must enter the file size value in KB. When you provide a decimal value to file Size field, the connector reads the value as zero and does fetch files from the directory. | For example, when you enter 70 as the value, the connector fetches files with file size equal to 70 KB. |
Starts with DatePattern | The connector selects file that starts with the specified date pattern in the file name. | For example, when you enter "YY-MM" as the value, the connector fetches files that begin with date "YY-MM" in its name. |
Ends with DatePattern | The connector selects file that ends with the specified date pattern in the file name. | For example, when you enter "MM-DD" as the value, the connector fetches files that end with date "MM-DD" in its name. |
Contains DatePattern | The connector selects file that contain the specified value. | For example, when you enter "MMM" as the value, the connector fetches files that contain date value "MMM" word in its name. |
Date or Time component | Presentation | Terminology (Date Patterns) | Examples |
|---|---|---|---|
ERA Designator | Text | G | GG:AD |
Year | Year | y | yyyy:2014, yy:14 |
Month in year | Month | M | MMMM:JUNE , MMM:JUN, MM:06 |
Week in year | Number | w | ww:45 |
Week in month | Number | W | W:2 |
Day in year | Number | D | DDD:227 |
Day in a month | Number | d | dd:09 |
Day of week in month | Number | F | F:3 |
Day in week | Text | E | E:Wednesday |
AM/PM marker | Text | a | aa:AM/PM |
Hour in day (0-23) | Number | H | HH:15 |
Hour in day (1-24) | Number | k | kk:24 |
Hour in am/pm (0-11) | Number | K | K:8 |
Hour in am/pm (1-12) | Number | h | hh:12 |
Minute in hour | Number | m | mm:45 |
Second in Minute | Number | s | ss:58 |
Millisecond | Number | S | SSS:450 |
Time Zone | General Time Zone | z | zzz:GMT |
Time Zone | RFC 822 Time | Z | ZZZ:-800 |