Latest Informatica Question & Answer

Question.1 The architectural difference between INFORMATICA 6.1 and 7.1

Answer: Few differences or the enhancements in 7.1, which I have noticed are VERSIONING in 7.1, Recovery, Can looking flat files.

Question.2 Can U tell how normalize works with an example?

Answer: Normalization is used to transform non tabular data structure into tabular format mainly required for COBOL data files.

Question.3 How do we deliver our mapping to client after creating in our system?

Answer: Export your mapping to an XML file and then import it to Client machine . I am assuming here the client and your system as same version and environment for INFORMATICA.

Question.4 How will you use surrogate key?

Answer: Surrogate keys are implemented by using the Sequence generator.

Question.5 When I was running workflow manager I.e. when I right click the task Icon and clicking start workflow from the task, I am getting a message like ‘cannot m connect to the server’
Can anybody guide me, how to get the output?

Answer: First check out whether the INFORMATICA service is running or not Sometimes the address will change every time so it is suggestible to resolve the server (server —server configuration ) and then start the service. Also check out the repository server configuration.

Question.6 In Source 1 to 100 numbers? How can we load the even number in One target and odd number in another target? explain the mapping ? How can we draw and which transformations we are using? and explain Logic?

Answer: Use a Router after the source, if the port has the number 1 to 1000 divided by 2 returns 0 then it belongs to Group 1 else Group 2. Send group 1 to one target , group 2 to 1 target.

Question.7 What is the difference between dynamic cache looking and uncached lookup?

Answer: Uncached lookup : The INFORMATICA server doesn’t build a cache for temporary storage of
data . Whenever it needs to refer to the lookup table. , it scans the source directly.
Dynamic Cache: The INFORMATICA server builds a cache of the source when the workflow runs for the first time and it updates the cache records dynamically after each row it loads to the target Means. ,if a target row gets updated ,the dynamic Cache also gets updated automatically after that particular row committed in the target.

Question.8 What r the two types of processes that INFORMATICA runs the session?

Answer: Load manager Process: Starts the session creates the DTM Process and sends post —-
session email when the session completes.
The DTM Process. Creates threads to initialize the session, read, write, and transform data
and handle pre—and operations.

Question.9 What r the new features of the server manager in the INFORMATICA 5.0?

Answer: U can use command line arguments for a session or batch. This allows U to change the values of session parameters, and mapping parameters and mapping variables. Parallel data processing : This feature is available for the power center only. If we use the info, MATICA server on an SMP system ,U can use multiple CPU’S to process a session concurrently.
Process session data using threads: INFORMATICA server runs the session in two processes.
Explained in the previous question.

Question.10 Which tool U use to create and manage sessions and batches and to monitor and stop the INFORMATICA server?

Answer: INFORMATICA server manager.

Question.11 What is Session and Batches?

Answer: Session—–A Session is A set of instructions that tells the INFORMATICA Server How And when To Move Data From Sources to Targets . After creating the session, we can use either the server manager or the command line program pm CMD to start the session. Batches it provides A Way to Group Sessions For Either Serial or Parallel Execution By the INFORMATICA Server .
There Are Two Types Of Batches.:
Sequential ——Run Session One after the Other concurrent —Run Session At the same time..

Question.12 What r the different options used to configure the sequential batches?

Answer: Two—-options.
Runs the session only if previous session completes successfully ,Always runs the session.

Question.13 How do we call shell scripts from INFORMATICA?

Answer: You can use a Command task to call the shell scripts, in the following ways:
Standalone Command task. You can use a Command task anywhere in the workflow or work let to run shell commands.
Pre—-and post—session shell command You can call a Command task as the pre—or post –
session shell command for a Session task. For more information about specifying pre-session and post-session shell commands.

Question.14 How to load time dimension?

Answer: One way to do this by using P1/SQL

Question.15 When we create a target as flat file and source as oracle… How can I specify first rows as column
names in flat files…

Answer: Use a pre SQL statement ……but this is a hard coding method….if you change the column names or put in extra columns in the flat file, you will have to change the insert statement

Question.16 How many types of facts and what are they?

Answer: There are Additive Facts, Semi—Additive , Non—Additive , Accumulating Facts, Fact fewer facts, Periodic fact table, Transaction Fact table.

Question.17 why and where we are using fact less fact table?

Answer: Fact fewer Fact Tables are the fact tables with no facts or measures (numerical data). It contains only the foreign keys of corresponding Dimensions.

Question.18 What transformation you can use in place of lookup?…

Answer: You can use the joiner transformation by setting as an outer join of either master or detail.

Question.19 How can I get distinct values while mapping in INFORMATICA in insertion?

Answer: You can add an aggregator before insert and group by the fields that need to the distinct.
IN the source qualifier write the query with distinct on key column.