Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Informatica Interview Questions
Questions Answers Views Company eMail

How does the session recovery work.

1 1349

Why use shortcuts(Instead of making copies).

1 2050

where is the reject loader .

1 1164

How do you use reject loader.


Do you have to change the reject file b4 using reject loader utility.

1 2050

Differences between version 7.x and 8.x.

Accenture, Cognizant,


Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.


Mapplets can you use an active transformation in a mapplet,

1 1897

What are active transformations? Name them.

1 1305

Can you use flat files in Mapplets.


How many transformations can be used in mapplets.


Can a joiner be used in a mapplet.

1 2570

What are active transformations.


How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.

1 1421

Global and Local shortcuts. Advantages.


Post New Informatica Questions

Un-Answered Questions { Informatica }

Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks


I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.


How do you convert single row from source into three rows into target?


Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?


What is the sequence generator transformation in informatica?


What is the need for an etl tool?


What is the status code in stored procedure transformation?


What is a node in Informatica?


Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?


How to generate sequence numbers using expression transformation?


Explain why we use partitioning the session in informatica?


If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?


Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?


What is the use of transformation?


Is it possible to define a single node as a Gateway node as well as worker node?