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 derfloh 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: *

  1. rasETL

    Date Format Conversion

    Your Suggestion should work - I hope you have already tried this. Let me know if you still have issues - I see if we have run into this before.
  2. rasETL

    Filter transformation - filter condition

    I have never used the SUBSTR function with a FILTER Transformation, so I am not sure if that works. Try creating a one character field in an expression transformation, then passing it to the filter transformation. If that doesn't work, see if a filter condition: CHK_FLD NE '~' works. Good luck
  3. rasETL

    Conditional insert into a Target

    I see two possibilities... One - pass the row thru a Router Transformation using a filter of count. to continue the record on. Two - Use a SQL Override in the Target Map to insert the row if the count is what you want it.
  4. rasETL

    Router Output to a "Single Target Table"

    sa0309 Set up multiple Target Maps of the same Table and have each router go it its own Target. We do this when we router inserts and deletes to one target map and deletes to another. If you need to you can set up / override the DML in the target.
  5. rasETL

    Insurance Claims Fact Table Question

    Scott We have set up two Lookup Tables 1. Payment Type - Loss, Expense, and Reserve (3 rows) 2. Patment Fact Type - Direct and Ceded (2 Rows) Include these two as columns in the Payment Fact Table
  6. rasETL

    to_date function

    Check out the "length" Transformation function. You can process the column differently based on length... IIF(Length(in_ADM_DATETIME)= 10
  7. rasETL

    Informatica Target Table update

    Since you want to update every row in the Table a Transformation will not work unless you process source transactions for every row. I think your best bet would be to add the Update DML to the "Post SQL" for the Target Mapping in the Session. Open the Session - Mapping Tab - Target - Scroll...
  8. rasETL

    Facebook Jobs Board--Please, Zuckerberg, Don't Do This!

    Hey - it has been reported that Mr. Zuckerberg has lost $9 Billion since the Facebook IPO. He needs to try and recover the Stock by "any means necessary". I personally have no social media accounts at all: wouldn't have the time to keep them up.
  9. rasETL

    Netezza with Informatica

    Yes - To the best of my knowledge, registering a Plug-in is required for any version.
  10. rasETL

    YouTube, Twitter, and Facebook to merge...

    Snap-On Tools and Electronics Company: Fujitsu will merge and become: SNAFU
  11. rasETL

    Netezza with Informatica

    Yes - you need to Register what Informatica refers to as a "PLUG-IN" ... 1.Log into the Administration Console 2.Restart the Repository Service in Exclusive mode 3.Click the Repository Service button 4.Click the Plug-ins tab 5.Register the plug-in pmnetezza.xml found in server/bin/Plugin...
  12. rasETL

    FILEAID TO SYNCSORT CONVERSION

    Adbhut I have a suggestion... Try using the following as a COND... INCLUDE COND=(6,7,CH,EQ,C'NOUSER5',OR,6,8,CH,EQ,C'TVASQU2 ',OR,6,7,CH,EQ,C'ZZZZZZZ') Not sure what the OPTION COPY VTOF is doing, but a VB File has 4 characters at the beginning which store the record length, so column 2 is...
  13. rasETL

    Webfocus Error (FOC277)

    Could you please post the Focexec: ADHOCRQ and the Focus File Definition (FFD) or Master File Definition (MFD) if you can get hold of it. The message is relatively straightforward...either there is a Group Level field definition that is incorrect, or a character mask is being identifoed...
  14. rasETL

    Unaccustomed as I am...

    This was not a speech, but I remember seeing a commercial where a person was meeting with potential clients. He started the presentation with... "Good Morning. But I digress.
  15. rasETL

    ...For you very punny people

    Best Career advice I ever heard... If you want to be outstanding in your field, become a Farmer.
  16. rasETL

    ...For you very punny people

    My wife hurt her knee. The Doctor asked where the injury was: her below knee or her high knee.
  17. rasETL

    ...For you very punny people

    Went to see a Proctologist the other day. I was surprised to find the waiting room packed. The receptionist said the Doctor was getting a little behind in his work.
  18. rasETL

    simple focus code giving error

    Change the first TABLE FILE command to... TABLE FILE CAR PRINT CAR COUNTRY SALES ON TABLE HOLD AS QWE END
  19. rasETL

    Variable Filtering Not Working

    jcollier3 It has been a long time since I worked with FOCUS, but I see a couple of items you might want to change... The field/flag: DISABLED is defined as A20 - if it is only going to be a 0 or 1, define it as A01 or Numeric. Also the variable &DISABLED - you might try changing the variable...
  20. rasETL

    Repeat Header File information for all records

    bampi777 I suggest using a Router Transformation. Send the one/first record with the date to one "stream", all other records to another stream. Then, concatenate the date before the flat file target. You need to determine a column that can be used to determine which "stream" to take. Hope...

Part and Inventory Search

Back
Top