Informatica Interview Questions
Questions Answers Views Company eMail

what is lookup ?

7 9581

what is the architecture of any Data warehousing project?

IBM,

5 14027

what is the flow?

1 5003




How to load time dimension?

Ford,

1 11754

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

7 17835

How do you create single lookup transformation using multiple tables?

TCS,

6 30649

Why touse stored procedure in ETL Application?

2 7838

How to improve the performance of Aggregate transformation?

Dmss,

3 9444




What is critical mapping?

2 7402

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

Accenture,

1 14759

How to view and Generate Metadata Reports?

1 5054

what is difference between COM & DCOM?

Satyam,

1 8404

what is the gap analysis?

1 6518

How to recover sessions in concurrent batches?

3 11290

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

TCS,

3 19611


Post New Informatica Questions






Un-Answered Questions { Informatica }

What is the Rank index port in Rank transformation?

15


WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

888


What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

6412


permutations of mapplet

1305


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

870






scenario where i can use only concurrent execution of workflow.

1827


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

794


Please let me know how to make encryption and decryption with example?

570


Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

993


What is confirmed fact in dataware housing?

4268


Whats there in global repository

630


What is option by which we can run all the sessions in a batch simultaneously?

13


EXL informatica Questions

235


My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

3952


hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

945