my-bi-stuff.blogspot.com
My BI Stuff: April 2010
http://my-bi-stuff.blogspot.com/2010_04_01_archive.html
Friday, April 30, 2010. The Audit Transform allows you to add auditing data to your Data Flow. In the age of HIPPA and. Sarbanes - Oxley (SOX) audits, you often must be able to track who inserted the data into a table and. When This transform helps you with that function. The following are some of the options you ’ ll have available to you:. Execution Instance GUID: The GUID that identifies the execution instance of the package. PackageID: The unique ID for the package. Posted by Anand Thakare. Sum: Retu...
jeffkinzer.blogspot.com
The Transaction Control | Jeff's Cluttered Mind
http://jeffkinzer.blogspot.com/2011/04/transaction-control.html
Ramblings on Informatica PowerCenter and SQL. Posted by J. Kinzer. Here is a sample mapping. To illustrate how the Transaction Control transformation can dynamically create multiple flat file outputs, each with a unique name and data set. The mapping reads a source table whose key is “Group Id”, and outputs a separate target file for each Group Id data set. The file names are also generated dynamically based on the Group Id. Overview of the mapping. Order the Source rows by the Key. The source input must...
jeffkinzer.blogspot.com
Using Informatica Environment Variables | Jeff's Cluttered Mind
http://jeffkinzer.blogspot.com/2010/05/using-informatica-server-environment.html
Ramblings on Informatica PowerCenter and SQL. Using Informatica Environment Variables. Posted by J. Kinzer. If you frequently use scripts to run PowerCenter commands pmrep. Make sure you are using server environment variables for repetitive command parameters. Benefits of using environment variables:. Eliminate the need to change scripts when migrating from test to production. Reduce need to change scripts when upgrading to new version of PowerCenter. Common environment variables for PowerCenter. The Pow...
jeffkinzer.blogspot.com
VBScript to Convert Excel to CSV | Jeff's Cluttered Mind
http://jeffkinzer.blogspot.com/2012/06/vbscript-to-convert-excel-to-csv.html
Ramblings on Informatica PowerCenter and SQL. VBScript to Convert Excel to CSV. Posted by J. Kinzer. Using Excel files as the source for Informatica mappings can be more trouble than it's worth. You have to setup a connection and name a range in the Excel document which can be difficult to maintain. I much prefer to read text or CSV files, they're simpler to work with and less error prone. I created a VB script for the purpose of converting Excel to CSV. Here's an overview of the script:. To make the scr...
jeffkinzer.blogspot.com
Misc Tips | Jeff's Cluttered Mind
http://jeffkinzer.blogspot.com/p/sql-tips.html
Ramblings on Informatica PowerCenter and SQL. Make a Copy of SQL Server Services Reports. Navigate to the location of the report, click Show details (right corner). Click the Edit icon next to the report. On the General tab under the "Report Definition" section, click "Edit", This prompts a Save dialogue. Click Update to replace the report definition. Find Max Date - Time from separate columns. Convert numeric to Date to SQL Server Date Type. Convert(Date, Convert(varchar, numeric column ). DATEADD(dd, D...
jeffkinzer.blogspot.com
Use A Mapping Parameter in an SAP ABAP Mapping | Jeff's Cluttered Mind
http://jeffkinzer.blogspot.com/2014/06/use-mapping-parameter-in-sap-abap.html
Ramblings on Informatica PowerCenter and SQL. Use A Mapping Parameter in an SAP ABAP Mapping. Posted by J. Kinzer. There are two areas for logic, the Dynamic Filter and the Static Filter. Use Static Filter and you don't have to create an ABAP block. Thank you for your support. 0 Response to "Use A Mapping Parameter in an SAP ABAP Mapping". Subscribe to: Post Comments (Atom). Many of the scripts referenced in this blog use server environment variables for repetitive command parameters. Read this post.
jeffkinzer.blogspot.com
SharePoint | Jeff's Cluttered Mind
http://jeffkinzer.blogspot.com/p/sharepoint.html
Ramblings on Informatica PowerCenter and SQL. Add Zebra striping to Survey. Redirect Survey after finish, use? PowerShell - finding Nouns. Gcm select Name, Noun Sort noun -unique Where {$ .noun -like "*user*"} get-date select -last 1 get-member where {$ .name -like "*year*"}. InfoPath - Conditional Field Values. Email Enable List or Library. Schedule PowerShell in Windows Task Scheduler. In the Action dialog, the program will be powershell. Subscribe to: Posts (Atom). Data Integration Hub Errors. YOU are...
jeffkinzer.blogspot.com
June 2012 | Jeff's Cluttered Mind
http://jeffkinzer.blogspot.com/2012_06_01_archive.html
Ramblings on Informatica PowerCenter and SQL. VBScript to Convert Excel to CSV. Posted by J. Kinzer 21 comments. Using Excel files as the source for Informatica mappings can be more trouble than its worth. You have to setup a connection and name a range in the Excel document which can be difficult to maintain. I much prefer to read text or CSV files, theyre simpler to work with and less error prone. I created a VB script for the purpose of converting Excel to CSV. Subscribe to: Posts (Atom). YOU are resp...
jeffkinzer.blogspot.com
VBScript to convert CSV to XLS | Jeff's Cluttered Mind
http://jeffkinzer.blogspot.com/2010/06/vbscript-to-convert-csv-to-xlsx.html
Ramblings on Informatica PowerCenter and SQL. VBScript to convert CSV to XLS. Posted by J. Kinzer. Informatica can easily output target data in comma separated value format (CSV) but sometimes you require output formatted in native Excel. Here's a reusable Visual Basic Script. That will convert a CSV file into a nicely formatted native Excel file. The script can be ran individually or as this tip will demonstrate, can be evoked from a PowerCenter Session's " Post-Session Success Command. Next, click the ...
