GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  Informatica
Go To First  |  Previous Question  |  Next Question 
 Informatica  |  Question 576 of 644    Print  
Repository deletion
what happens when a repository is deleted?
If it is deleted for some time and if we want to delete it permanently?
where is stored (address of the file)


  
Total Answers and Comments: 2 Last Update: December 03, 2007     Asked by: adhika 
  
 Sponsored Links

 
 Best Rated Answer
—
Submitted by: sandeep_sajjan
 
repository is stored in database ,go  in repository admin console right click on repository then choose delete . a dialog box is displayed fill up the user name(database user wr ur repository is reside),give password and fill all the field .thereafter u can delete it. if any queries plz mail me sajjan.s25@gmail.com

Above answer was rated as good by the following members:
vasirev
November 28, 2007 22:36:19   #1  
chandrarekha Member Since: May 2007   Contribution: 14    
RE: Repository deletion
I too want to know the answer for this question

I tried to delete the repository that time it was deleted after that i tried to create the repository with the same name what i was deleted earliar it is showing the repositort exist in the target
we have to delete the repository in the target database
 
Is this answer useful? Yes | No
December 03, 2007 08:33:37   #2  
sandeep_sajjan Member Since: December 2007   Contribution: 1    
RE: Repository deletion
repository is stored in database go in repository admin console right click on repository then choose delete . a dialog box is displayed fill up the user name(database user wr ur repository is reside) give password and fill all the field .thereafter u can delete it. if any queries plz mail me sajjan.s25@gmail.com
 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    

 Related Questions

Comment posted by: Deb on 2005-06-08 00:56:53Ans: While running a Workflow,the PowerCenter Server uses the Load Manager process and the Data Transformation Manager Process (DTM) to run the workflow and 
Latest Answer : I am providing the answer which I have taken it from Informatica 7.1.1 manual,  Ans: While running a Workflow,the PowerCenter Server uses the Load Manager process and the Data Transformation Manager Process (DTM) to run the workflow and carry ...
COBOL source definition Joiner transformations Normalizer transformations Non reusable sequence generator transformations. Pre or post session stored procedures Target defintions Power mart 3.5 style Look 
Latest Answer : −Normalizer transformations−Cobol sources−XML Source Qualifier transformations−XML sources−Target definitions−Pre- and post- session stored procedures−Other mapplets-PowerMart 3.5-style LOOKUP functions-non reusable ...
Maping parameter represents a constant value that U can define before running a session.A mapping parameter retains the same value throughout the entire session. When u use the maping parameter ,U declare 
Latest Answer : Mapping parameter represents a constant value defined before mapping run. Mapping reusability can be achieved by using mapping parameters. Mapping variable represents a value that can be changed during the mapping run. Mapping variable can be used ...
It is a web based application that enables you to run reports againist repository metadata. With a meta data reporter,u can access information about U’r repository with out having knowledge of sql,transformation 
Tags : Metadata
When u edit,schedule the sesion each time,informatica server directly communicates the repository to check whether or not the session and users r valid.All the metadata of sessions and mappings will be 
Manages the session and batch scheduling: Whe u start the informatica server the load maneger launches and queries the repository for a list of sessions configured to run on the informatica server.When 
Latest Answer : How can you determine, whether informatica server is running or not with out using event viewer by using shell command. I would appreciate the solution for this one. Feel free to mail me at puli.reddy@gmail.com ...
Yes. By using copy session wizard u can copy a session in a different folder or repository.But that target folder or repository should consists of mapping of that session. If target folder or repository 
Latest Answer : In addition, you can copy the workflow from the Repository manager. This will automatically copy the mapping, associated source,targets and session to the target folder. ...
The goal of performance tuning is optimize session performance so sessions run during the available load window for the Informatica Server.Increase the session performance by following. The performance 
Latest Answer : Hey, Thank You so much for the information. That was one of the best answers I have read on this website. Descriptive yet to the point and highly useful in real world. I appreciate your effort. ...
The Informatica repository is a relational database that stores information, or metadata, used by the Informatica Server and Client tools. Metadata can include information such as mappings describing how 
Latest Answer : Infromatica Repository:The informatica repository is at the center of the informatica suite. You create a set of metadata tables within the repository database that the informatica application and tools access. The informatica client and server access ...
Following r the types of metadata that stores in the repository Database connections Global objects Mappings Mapplets Multidimensional metadata Reusable transformations Sessions and batches Short cuts 
Latest Answer : Source definitions. Definitions of database objects (tables, views, synonyms) or files that provide source data. Target definitions. Definitions of database objects or files that contain the target data. Multi-dimensional metadata. Target definitions ...
Tags : Metadata

 Sponsored Links

 
Related Articles

Breaking up XML into Relational Data

Breaking up XML into Relational Data While the preceding example shows how to construct an XML representation over relational data the example in this section illustrates how you can shred XML data back into relational data This reverse operation can be useful if your application works with relation
 

Querying Data with Oracle XQuery

Querying Data with Oracle XQuery Starting with Oracle Database 10g Release 2 you can take advantage of a full featured native XQuery engine integrated with the database With Oracle XQuery you can accomplish various tasks involved in developing PHP Oracle XML applications operating on any kind of dat
 

Accessing Repository Resources with SQL

Accessing Repository Resources with SQL In fact Oracle XML DB repository resources are stored in a set of database tables and indexes which can be accessed via SQL You are not supposed to access those tables directly Instead Oracle XML DB provides two public views RESOURCE VIEW and PATH VIEW through
 

Using Oracle XML DB Repository

Using Oracle XML DB Repository Another variation on accessing and manipulating XML content stored in Oracle database is provided by Oracle XML DB repository which is an essential component of Oracle XML DB mosgoogle NOTE Oracle XML DB repository also known as XML repository is a hierarchically organ
 

Retrieving XML Data

Retrieving XML DataTo retrieve XML data from an XMLType table you can use a SELECT SQL statement just as you would if you had to query a relational table For example to select the employee with the id set to 100 from the employees XMLType table discussed in the preceding section you might issue the
 

Using XMLType for Handling XML Data in the Database

Using XMLType for Handling XML Data in the Database Being an object type XMLType can not only be used to store XML data in the database but also to operate on that data via its built in methods Regardless of the storage model you choose XMLType provides a set of XML specific methods to operate on XM
 

Using Oracle Database for Storing, Modifying, and Retrieving XML Data

Using Oracle Database for Storing Modifying and Retrieving XML Data With Oracle XML DB you have various XML storage and XML processing options allowing you to achieve the required level of performance and scalability One of the most interesting things about Oracle XML DB is that it allows you to per
 

ODP.NET - Techniques to Improve Performance while Retrieving Data

ODP NET Techniques to Improve Performance while Retrieving Data Performance tuning is a great subject in Oracle Volumes of books would not be enough to cover every aspect of performance tuning in Oracle However in this section we will only discuss the fundamental performance techniques while working
 

ODP.NET - Populating a Dataset with a Single Data Table

ODP NET Populating a Dataset with a Single Data Table A dataset is simply a group of data tables These data tables can be identified with their own unique names within a dataset You can also add relations between data tables available in a dataset mosgoogle The following code gives you the details o
 

ODP.NET - Retrieving Typed Data

ODP NET Retrieving Typed Data While retrieving values from OracleDataReader we can extract information available in individual columns of a particular row either by using column ordinal position values or column names mosgoogle Retrieving Typed Data Using Ordinals ODP NET provides data specific enum
 

About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape