The Definitive Guide to Data Quality
Here's how I would do it:
1. Use the tSetGlobalVar component to create a global variable called "varTime" (alternatively you could just create a context variable called "varTime"
2. Inside the tFileList loop mentioned above, set the value of the varTime variable using a tJava component. You'll need to parse the filename to extract the value needed. It should look something like this: globalMap.put("varTime", <<extracted string>>); If you chose to use a context variable, it would look more like this: context.varTime = <<extracted string>>;
3. Now you probably have a tOracleInput (or other database input) inside the tFileList loop. If so, then modify your query like this: select * from ABC where time = '" + ((String)globalMap.get("varTime")) + "'" (use single quotes as needed depending on the database and data types)
Hope this helps!