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

Informatica Interview Questions
Questions Answers Views Company eMail

tell me 5 session failure in real time how can you solve that in your project?



what type of documents you receiving from client later wt can you do? what type of documents have to prepare?


2 5110

explain about unit testing? in real time?



we have 30 wf with 3 batches means 1batch=10 wf 2 batch=10-20 wf 3batch=20-30wf through unix First you have to complete batch ofter second batch have to run how can you do in unix?


1 5093

wf dont have integration severances how you can run?



how can run the wf through pmcmd commend? write script?

Cap Gemini,

2 7103

how to return multiple columes through through un-connect lookup?


1 5617

explain one complex mapping with logic? sales project?

Accenture, JPMorgan Chase,


Performance tuning in UNIX for informatica mappings?



How to Migrate the UNIX SCRIPTS from SIT TO PROD?

1 1977

How to do the error handling of if ur source is flatfiles?


In ur current projectu have done any performance tuning of mappings?

1 3658

In which scenario did you used pushdown optimization?

1 2220

In which scenario did u used Mapping variable?


1 1628

In Which scenario did u used Incremental loading?

2 4909

Post New Informatica Questions

Un-Answered Questions { Informatica }

hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?


Can we override a native sql query within 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


what is the -ve test case in your project.


What are the tuning techniques you applied during your last project


Define mapping and session?


in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records


Explain load alternative records / rows into multiple targets - informatica


What is a joiner transformation and why it is an active one?


what are the best practices to extract data from flat file source which are bigger than 100 mb memory?


How to start a workflow using pmcmd command?


How to differentiate between the active and passive transformations?


5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C


Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps


How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how