“What is ETL ? ” Probably , You might also need to know this term because somewhere you would have come across one of following term like “ETL tools”, “ETL technology”, “ETL integration” etc , etc …. and one of these term would have put interest in you to know more about that “what it is?”.

Download E-book on HOW TO INSTALL SQL SERVER 2008 ON WINDOWS XP and 7.You can go through below steps ( avoid PDF ) to install SQL Server 2008 without referring pictures.Step 1# Click Setup.exe to run install SQL server 2008 Console. Step 2# Click on hardware and Software requirements.

an informatica dynamic parameter file parameter file can be created dynamically and changes before every batch job execution (Every workflow run) .Its dynamic nature provides flexibility. In informatica dynamic parameter file we can add/remove parameters as well parameter values in it automatically by a mapping. Dynamic parameter file capability supports changing needs of project data load.

Do we need ETL Tool? Answer is “Yes”. They are must for organization which are of enormous size and having many applications serving there different IT needs.

Informatica help-Some basic facts Search is not case sensitive. Phrases not considered; Like $,#,^,&, if used it throws error “Help Cannot search for that phrase” Every word is used; Example “Lookup cache” will search informatica help for lookup and cache both. 6 Tips for improved searches Broad Search- For search terms “lookup cache” it will search informatica help for lookup and cache both. Phrase Search- You need to put in double quotes to search the help for exact phrase. Example [...]

Informatica Views, also known as informatica metadata tables/Views provides object named as REP_SESS_TBL_LOG which can be used to get the all the session which populates specific target table.
Moreover its must to know, if someone is in application enhancement phase where some systems are getting obsolete,

Just to be in sync which this change all database objects also need to be cleaned up in respective client applications,
For example, what if one fine day you get to know that your CRM system is migrating to SAP and you will no longer receiving data after a certain date from your current CRM system, Lets assume if you are feeding to CRM then all your jobs pointing to it will start aborting one by one.

What is etl performance testing Generally etl performance testing is confirmation test to ensure that an ETL ‘system’ can handle the load of multiple users and transaction.  For any project this is primarily ensuring the ‘system’ can easily manage the throughput of millions of transactions. Emphasizing ‘system’ because the system is the application(s) +Components + hardware + databases + network. What is performance test plan Any performance test plan contains some number of performance tests, Like milestone for Go-Live activities (Example: 85k transaction processing in a [...]

Sample SQL uses Informatica metadata tables and find out long running sessions, Exa: metadata tables REP_TASK_INST_RUN and OPB_SESS_TASK_LOG. You can even use it to pull information for a specific time range also, like long running sessions for last two days, Code for time range is marked in green.

REP_57060 Login failure UM_10016 The Service Manager failed to authenticate user belonging to Native. ****** Get in touch with your project informatica admin to reset your user name password.

OPB_WFLOW_RUN is informatica ETL tool metadata table, Metadata also known as repository as well. OPB_WFLOW_RUN keeps workflow run status.