Answer / j.david sukeerthi kumar

Hi

Informatica repository is a central meta-data storage place,
which contains all the information which is necessary to
build a data warehouse or a data mart.

Meta-data like source def,target def,business
rules,sessions,mappings,workflows,mapplets,worklets,database
connections,user information, shortcuts etc

Answer / purna

Repository is Brain of Informatica.
In every project must and should to use one or more repository.
It is metadata object

1. When u r checking out what ll happens for version no? a. Increase b. decrease c.reset to 0 d. reset to 1 e. no change 2. Salary of all employees needed to add with the commision. What transfrmation to be used? a. SQ and Expression b. SQ c. Update Strategy d. Expression 3. Which of the task is used to run a session based on success of the other session? a. Decision b. Event wait c. Email d. Command e. None 4. Types of sources in Informatica? a. Homogenous n Heterogenous b. None c. Cobol n XML d. Flat files e. Flat files and Homogenous n Heterogenous 5. Servers are available in informatica? a. Informatica Server and Workflow server b. Informatica Server and Informatica Repository Server c. Informatica Server d. Workflow server e. Informatica Repository Server 6. While using Pmcmd in cmd line mode, each command must include the connection info of which of the following? a. workflow manager b. Power Center server c. Workflow monitor d. Repository manager e. Designer 7. Workflow montior displays workflows that have run a. once b. twice c. never d.four times e. thrice 8. Mode for handling sessions n workflows? a. server mode b. Wait mode c. Command line mode d. User mode e. Interactive mode 9. Connection details configured in? a. Mapping designer b. Workflow manager c. Workflow monitor d. Repository manager e. Worklet designer Thanks in Advance

0 Answers   CTS,

---

SOURCE NAME SAL GANGA 30000 RAJU 20000 PAVAN 25000 TARGET NAME SAL MAXSAL GANGA 30000 30000 RAJU 20000 30000 PAVAN 25000 30000 in mapping level how to achive that

5 Answers   DELL,

---

In Flat file Input is A B C I need output like this A A A B B B C C C. How will u achieve this?

5 Answers   iNautix,

---

What are the types of lookup transformation?

0 Answers   Informatica,

---

why we use stored procedure transformation?

4 Answers   IBM,

---

explain abt ur project architecture?

0 Answers   Anthem, DELL, IBM, TCS, Wipro,

---

what is the location of parameter file in informatica?

1 Answers   TCS,

---

what is mapping performence?

2 Answers   Cap Gemini,

---

How does the server recognize the source and target databases. Elaborate on this.

1 Answers  

---

How can we handle two sessions in informatica?

0 Answers  

---

How to convert flat file into xml file? How to tune joiner?

2 Answers   Accenture,

---

I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.

3 Answers  

---