Follow Our FB Page << CircleMedia.in >> 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.

1560

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,

957

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.

1407

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.

1702

How many transformations can be used in mapplets.

1053

Can a joiner be used in a mapplet.

1 2570

What are active transformations.

781

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

1 1421

Global and Local shortcuts. Advantages.

1070


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

1037


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.

270


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

200


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?

1130


What is the sequence generator transformation in informatica?

208






What is the need for an etl tool?

230


What is the status code in stored procedure transformation?

274


What is a node in Informatica?

235


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?

861


How to generate sequence numbers using expression transformation?

247


Explain why we use partitioning the session in informatica?

237


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?

6866


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?

275


What is the use of transformation?

238


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

234