Profile cover photo
Profile photo
DWBI Guru
About
DWBI's posts

Post has attachment
Sample parameter file and using parameter file in Informatica
Sample parameter file and using parameter file in Informatica Below is a sample of a simple parameter file. All the global variables used by all the sessions are defined under [Global] and the session specific variable overrides are defined under session na...

Post has attachment
Find all columns with only nulls in SQL Server table
Find all column fields with only nulls in SQL Server table The piece of code below will give list of all columns that have only nulls in a give table. Replace YourTableName with your tablename in the code below. This is variation of code that I found here (...

Post has attachment
Static vs Dynamic Lookup in Informatica
Difference between Static vs Dynamic Lookup In Informatica Static Lookups:  These are are used when you want to lookup a value on a static table or a SQL query based on certain matching conditions. It caches the values when the static lookup in created at t...

Post has attachment
How to Loop in SQL server?
How to Loop in SQL server?  The below example shows how to loop in microsoft SQL server and insert records in chunks: This makes inserts faster. SET IDENTITY_INSERT dbo.table1 ON /* This is required if you are adding data to Identity columns */ DECLARE @cnt...

Post has attachment
SQL server and azure troubleshooting - common issues
 SQL server and azure troubleshooting - common issues 1) Msg 245, Level 16, State 1, Line 2 Conversion failed when converting the varchar value '000005EW84' to data type int. Resolution: this issue happens when there is character in the column that you are ...

Post has attachment
Improving performance of Inserts and deletes in SQL server
Improving performance of Inserts and deletes in SQL server  - Microsoft Azure I tried to delete some records from a table with 100 millions records and it took forever. One of the reason being there was no index on the column I used in the where clause of t...

Post has attachment
Performance tuning of Informatica Big Data Edition Mapping
Performance tuning of Informatica Big Data Edition Mapping Below are the list of performance tuning steps that can be done in Informatica Big Data Edition: 1)  When using a look up transformation only when the lookup table is small. Lookup data is copied to...

Post has attachment
Workarounds for Mapping variables and parameters and sequence generators and sorters in BDE
Mapping variables and parameters and sequence generators and sorters in BDE Since there are no mapping variables/parameters and sequence generators in BDE, you can use the following workarounds: For mapping variables and parameters, you can use a control ta...

Post has attachment
Useful Queries for troubleshooting amazon redshift
USEFUL QUERIES FOR TROUBLESHOOTING IN AMAZON REDSHIFT  Here are some of my queries for troubleshooting in amazon redshift. I have collected this from different sources. TO CHECK LIST OF RUNNING QUERIES AND USERNAMES: select a.userid, cast(u.usename as varch...

Post has attachment
How to run stored procedure in Informatica cloud
How to run stored procedure in Informatica cloud? There are multiple ways to run stored procedure in Informatica cloud. If you want to call a stored procedure by passing an input value and reading the output from the stored procedure and process it in a map...
Wait while more posts are being loaded