Security Key is Invalid or Unavailable in DAC

I have encountered this error in my work recently.We can resolve this by following these steps.There is dac repository table called W_ETL_REPO,in this table we have a record for key validation.

Just remove that record carefully,and remove a record from W_ETL_USER because we will get below error.After this step it will ask you to create a new key.

Target Pre SQL To Drop All Indexes

The Following Procedure may useful to drop all bit map indexes from a particular table.We can use Mapping parameters to pass the table name dynamically.

CREATE or REPLACE Procedure Drop_All_Indexes
Is
Cur Integer;
Begin
cur:= dbms_sql.OPEN_CURSOR();
For t in (Select index_name from INDEXES_INFO where table_name='EMP' AND uniqueness='NONUNIQUE' AND index_type='BITMAP') loop
Execute immediate ' drop index ' || t.index_name;
End loop;
dbms_sql.close_cursor(cur);
End;
/
EXECUTE Drop_All_Indexes;

Export and Import options in Informatica

If we want to move mappings from one repository to another,we can use  export and import options in informatica.

Better to do this export and imports from repository manager.If we want to move any mapping,export that particular mapping workflow,then we will get all object regarding to that mapping(sources,targets,mappings,session,workflow).

If you export mapping,you will miss session and workflow s. if you export session you will miss workflow.So it’s always better to do this export and imports on workflows.

 

Specify the location where you want to save this XML file and click on export.

 

Click on Close.Connect to the other repository and open repository manager.

 

Click on Import Option.

 

Brose to the Location where you have saved our mapping XML file.

 

Click on Add All.

 

Select Destination Folder like above.

 

Click the check box for Reuse option.

 

Click on Import button.

 

Click on Done,we have successfully imported mapping in to another repository.