Access over 20 million homework & study documents

What are the components of Informatica?

Content type
User Generated
Type
Study Guide
Rating
Showing Page:
1/83
1
Informatica Questionnaire
1. What are the components of Informatica? And what is the purpose of each?
Ans: Informatica Designer, Server Manager & Repository Manager. Designer for Creating Source & Target
definitions, Creating Mapplets and Mappings etc. Server Manager for creating sessions & batches, Scheduling
the sessions & batches, Monitoring the triggered sessions and batches, giving post and pre session commands,
creating database connections to various instances etc. Repository Manage for Creating and Adding
repositories, Creating & editing folders within a repository, Establishing users, groups, privileges & folder
permissions, Copy, delete, backup a repository, Viewing the history of sessions, Viewing the locks on various
objects and removing those locks etc.
2. What is a repository? And how to add it in an informatica client?
Ans: It’s a location where all the mappings and sessions related information is stored. Basically it’s a database
where the metadata resides. We can add a repository through the Repository manager.
3. Name at least 5 different types of transformations used in mapping design and state the use of each.
Ans: Source Qualifier Source Qualifier represents all data queries from the source, Expression Expression
performs simple calculations,
Filter Filter serves as a conditional filter,
Lookup Lookup looks up values and passes to other objects,
Aggregator - Aggregator performs aggregate calculations.
4. How can a transformation be made reusable?
Ans: In the edit properties of any transformation there is a check box to make it reusable, by checking that it
becomes reusable. You can even create reusable transformations in Transformation developer.
5. How are the sources and targets definitions imported in informatica designer? How to create Target
definition for flat files?
Ans: When you are in source analyzer there is a option in main menu to Import the source from Database, Flat
File, Cobol File & XML file, by selecting any one of them you can import a source definition. When you are in
Warehouse Designer there is an option in main menu to import the target from Database, XML from File and
XML from sources you can select any one of these.
There is no way to import target definition as file in Informatica designer. So while creating the target definition
for a file in the warehouse designer it is created considering it as a table, and then in the session properties of
that mapping it is specified as file.
6. Explain what is sql override for a source table in a mapping.
Ans: The Source Qualifier provides the SQL Query option to override the default query. You can enter any SQL
statement supported by your source database. You might enter your own SELECT statement, or have the
database perform aggregate calculations, or call a stored procedure or stored function to read the data and
perform some tasks.
7. What is lookup override?
Ans: This feature is similar to entering a custom query in a Source Qualifier transformation. When entering a
Lookup SQL Override, you can enter the entire override, or generate and edit the default SQL statement.
The lookup query override can include WHERE clause.
8. What are mapplets? How is it different from a Reusable Transformation?
Ans: A mapplet is a reusable object that represents a set of transformations. It allows you to reuse
transformation logic and can contain as many transformations as you need. You create mapplets in the Mapplet
Designer.
Its different than a reusable transformation as it may contain a set of transformations, while a reusable
transformation is a single one.
9. How to use an oracle sequence generator in a mapping?

Sign up to view the full document!

lock_open Sign Up
Showing Page:
2/83
2
Ans: We have to write a stored procedure, which can take the sequence name as input and dynamically
generates a nextval from that sequence. Then in the mapping we can use that stored procedure through a
procedure transformation.
10. What is a session and how to create it?
Ans: A session is a set of instructions that tells the Informatica Server how and when to move data from sources
to targets. You create and maintain sessions in the Server Manager.
11. How to create the source and target database connections in server manager?
Ans: In the main menu of server manager there is menu “Server Configuration”, in that there is the menu
“Database connections”. From here you can create the Source and Target database connections.
12. Where are the source flat files kept before running the session?
Ans: The source flat files can be kept in some folder on the Informatica server or any other machine, which is in
its domain.
13. What are the oracle DML commands possible through an update strategy?
Ans: dd_insert, dd_update, dd_delete & dd_reject.
14. How to update or delete the rows in a target, which do not have key fields?
Ans: To Update a table that does not have any Keys we can do a SQL Override of the Target Transformation by
specifying the WHERE conditions explicitly. Delete cannot be done this way. In this case you have to
specifically mention the Key for Target table definition on the Target transformation in the Warehouse Designer
and delete the row using the Update Strategy transformation.
15. What is option by which we can run all the sessions in a batch simultaneously?
Ans: In the batch edit box there is an option called concurrent. By checking that all the sessions in that Batch will
run concurrently.
16. Informatica settings are available in which file?
Ans: Informatica settings are available in a file pmdesign.ini in Windows folder.
17. How can we join the records from two heterogeneous sources in a mapping?
Ans: By using a joiner.
18. Difference between Connected & Unconnected look-up.
Ans: An unconnected Lookup transformation exists separate from the pipeline in the mapping. You write an
expression using the :LKP reference qualifier to call the lookup within another transformation. While the
connected lookup forms a part of the whole flow of mapping.
19. Difference between Lookup Transformation & Unconnected Stored Procedure Transformation
Which one is faster ?
20. Compare Router Vs Filter & Source Qualifier Vs Joiner.
Ans: A Router transformation has input ports and output ports. Input ports reside in the input group, and output
ports reside in the output groups. Here you can test data based on one or more group filter conditions.
But in filter you can filter data based on one or more conditions before writing it to targets.
A source qualifier can join data coming from same source database. While a joiner is used to combine data from
heterogeneous sources. It can even join data from two tables from same database.
A source qualifier can join more than two sources. But a joiner can join only two sources.
21. How to Join 2 tables connected to a Source Qualifier w/o having any relationship defined ?
Ans: By writing an sql override.
22. In a mapping there are 2 targets to load header and detail, how to ensure that header loads first then
detail table.

Sign up to view the full document!

lock_open Sign Up
Showing Page:
3/83

Sign up to view the full document!

lock_open Sign Up
End of Preview - Want to read all 83 pages?
Access Now
Unformatted Attachment Preview
Informatica Questionnaire 1. What are the components of Informatica? And what is the purpose of each? Ans: Informatica Designer, Server Manager & Repository Manager. Designer for Creating Source & Target definitions, Creating Mapplets and Mappings etc. Server Manager for creating sessions & batches, Scheduling the sessions & batches, Monitoring the triggered sessions and batches, giving post and pre session commands, creating database connections to various instances etc. Repository Manage for Creating and Adding repositories, Creating & editing folders within a repository, Establishing users, groups, privileges & folder permissions, Copy, delete, backup a repository, Viewing the history of sessions, Viewing the locks on various objects and removing those locks etc. 2. What is a repository? And how to add it in an informatica client? Ans: It’s a location where all the mappings and sessions related information is stored. Basically it’s a database where the metadata resides. We can add a repository through the Repository manager. 3. Name at least 5 different types of transformations used in mapping design and state the use of each. Ans: Source Qualifier – Source Qualifier represents all data queries from the source, Expression – Expression performs simple calculations, Filter – Filter serves as a conditional filter, Lookup – Lookup looks up values and passes to other objects, Aggregator - Aggregator performs aggregate calculations. 4. How can a transfor ...
Purchase document to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Anonymous
Super useful! Studypool never disappoints.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4