Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: glenpark
  • Content: Threads
  • Order by date
  1. glenpark

    Number of day in a quarter?

    Hey everyone, I've been working on this concept for a little while but still having trouble knocking out a solution. Based on a timestamp, is it possible to extract what number of day it is in a quarter? For instance, January through March of 2007 would be quarter 1 and hence February 2nd...
  2. glenpark

    Help with Export/Import statement

    I did a little searching but didn't find exactly what I was looking for. Would there be a problem with doing an EXPORT of data from a table into a flat file, adding a column to the table, then executing an IMPORT into that table? Assuming that new column is non-nullible and carries a default...
  3. glenpark

    Problem with dynamic cache

    Hey everyone, I'm having some trouble with a dynamic lookup. I'm betting that it's just a small problem but I just can't see it so I need another pair of eyes. Here's the problem: The dynamic lookup is on the target table in a mapping that loads a type 2 slowly changing dimension. It...
  4. glenpark

    Variable-depth hierarchy

    Hello again, So now I have a bit more of a difficult problem to solve. Has anyone had to deal with a variable-depth hierarchy? I have one as a source and have to load it into a type 2 SCD. Looking around online, I see references to this but they all seem to only be taught in paid courses...
  5. glenpark

    Same table in source and target

    Well I'm back again =D So I have a conceptual question... I've been given a source and target for a mapping that involve the same table. The source is actually a view made up of columns from two tables, one of which is also my target table. My question is regarding whether there's any danger...
  6. glenpark

    Shared dynamic cache?

    Hello, Ok so I need a little help with a problem conceptually here. I'm constructing a mapping that loads a type 2 slowly changing dimension. Which means I have to use a dynamic lookup against the target table to synchronize inserts/updates between it and the lookup cache. Now, I have...
  7. glenpark

    Error in expression editor

    Hello! I'm running into an error message in the expression editor when running this IIF statement: IIF(conditionA=1,UpdateDate, IIF(conditionB=1 OR conditionC=1,null)) All three conditions are small int variable ports. This IIF statement is contained in a variable part that is string...
  8. glenpark

    Command Tasks and File Detection

    I can't seem to find a similar situation on here so here I go. I'm running INFA 7.x on Linux and need to use a command task to detect a flat file before running a workflow. I can't use an event wait because the workflow needs to run whether the flat file is there or not. So basically when the...

Part and Inventory Search

Back
Top