Friday, September 11, 2015

How to use multiple values in a parameter with Informatica, with IN function/clause

›
Several times we have to use a list of values for filter. It becomes a tedious job, when the list keep changing frequently. Now using param...

How to create and use a Parameter file in Informatica

›
              I know how tedious and painful it is to change and migrate the code every time you have to do a little change. On the other h...
Wednesday, September 18, 2013

How to Delete duplicate records in Oracle table

›
Many times we get duplicate records in a table. Mostly we can truncate the whole table and reload it again from source, but if the table is...
Tuesday, July 16, 2013

How to truncate a partition of a table in Oracle with Informatica Pre SQL

›
So, I only wanted to delete a set of data from a huge table and not wanted to truncate the whole table, as it would take long time to reloa...
1 comment:

List all the table information with specified column_name

›
Say, we have a column_name and we want to find out which table it belongs to, or to know all the tables and views have this column. Here is...
Tuesday, June 25, 2013

How to Create Index on a table in Oracle

›
Here is the syntax to create an index on a table in oracle: CREATE INDEX INDEX_NAME ON TABLE_NAME(COLUMN_NAME); If you want to specify ...
Wednesday, June 19, 2013

How to add more columns to an existing table with a simple SQL in Oracle

›
Most of you may know that you can add a column easily with Toad by going through add column wizard or Alter table wizard. Let's say if ...