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

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

CSC,

1459

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

CGI,

2 5110

explain about unit testing? in real time?

L&T,

1463

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?

Polaris,

1 5093

wf dont have integration severances how you can run?

TCS,

1366

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

Cap Gemini,

2 7103

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

DELL,

1 5617

explain one complex mapping with logic? sales project?

Accenture, JPMorgan Chase,

5696

Performance tuning in UNIX for informatica mappings?

CGI, CTC,

1968

How to Migrate the UNIX SCRIPTS from SIT TO PROD?

1 1977

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

1344

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?

Cognizant,

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?

1364


Can we override a native sql query within informatica?

440


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

1259


what is the -ve test case in your project.

1625


What are the tuning techniques you applied during your last project

1392






Define mapping and session?

434


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

1531


Explain load alternative records / rows into multiple targets - informatica

496


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

419


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

1754


How to start a workflow using pmcmd command?

521


How to differentiate between the active and passive transformations?

466


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

1230


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

1480


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

983