Recent content by rasETL

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.

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

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.

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.

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

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

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...

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.

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

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

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...

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...

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...

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.

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