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

what is lookup ?

7 12308

what is the architecture of any Data warehousing project?

IBM,

5 17081

what is the flow?

1 6194

How to load time dimension?

Ford,

1 13562

In update strategy target table or flat file which gives more performance ? why?

7 21601

How do you create single lookup transformation using multiple tables?

TCS,

6 38074

Why touse stored procedure in ETL Application?

2 9359

How to improve the performance of Aggregate transformation?

Dmss,

3 11367

What is critical mapping?

2 9145

How to call stored Procedure from Workflow monitor in Informatica 7.1 version?

Accenture,

1 17599

How to view and Generate Metadata Reports?

1 6174

what is difference between COM & DCOM?

Satyam,

1 9478

what is the gap analysis?

1 7528

How to recover sessions in concurrent batches?

3 13103

what are the different types of transformation available in informatica and what are the mostly used ?

TCS,

3 22309


Post New Informatica Questions






Un-Answered Questions { Informatica }

What is a transaction control transformation?

467


What is the need for an etl tool?

402


what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1273


what are factless facts? And in which scenario will you use such kinds of fact tables.

1099


What is the difference between informatics 7x and 8x and what is latest version?

326






How do you remove duplicate records in informatica? And how many ways are there to do it?

400


What is the difference between router and filter?

377


Plz can any one say me how to get the informatica certification materials and dumps

1363


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

1194


where to store informatica rejected data? How to extract the informatica rejected data?

369


what is informatica metadata?

373


What is different between the data warehouse and data mart?

426


How to create Target definition for flat files?

456


How might you approve all mappings in the archive all the while?

335


What is union transformation?

348