Informatica Interview Questions
Questions Answers Views Company eMail

what is lookup ?

7 13960

what is the architecture of any Data warehousing project?

IBM,

5 18500

what is the flow?

1 6947

How to load time dimension?

Ford,

1 14419

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

7 23446

How do you create single lookup transformation using multiple tables?

TCS,

6 41356

Why touse stored procedure in ETL Application?

2 10301

How to improve the performance of Aggregate transformation?

Dmss,

3 12411

What is critical mapping?

2 9941

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

Accenture,

1 18556

How to view and Generate Metadata Reports?

1 6776

what is difference between COM & DCOM?

Satyam,

1 10168

what is the gap analysis?

1 8112

How to recover sessions in concurrent batches?

3 14094

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

TCS,

3 23632


Post New Informatica Questions

Un-Answered Questions { Informatica }

write a query to retrieve the latest records from the table sorted by version(scd)

605


Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?

2400


What is rank transform?

575


What are data-driven sessions?

682


What do mean by local and global repository?

667






How many ways a relational source definition can be updated and what are they?

549


What is pmcmd command?

638


What do you understand by a term domain?

646


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

1382


What are the components of workflow manager?

552


Briefly explain the aggregator transformation?

568


Different circumstance which drives informatica server to expel records?

525


What is meant by lookup transformation?

586


What are the different types of transformation available in informatica.

604


What is an expression transformation?

568