Informatica Interview Questions
Questions Answers Views Company eMail

what is lookup ?

7 9278

what is the architecture of any Data warehousing project?

IBM,

5 13726

what is the flow?

1 4820




How to load time dimension?

Ford,

1 11513

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

7 17435

How do you create single lookup transformation using multiple tables?

TCS,

6 29921

Why touse stored procedure in ETL Application?

2 7678

How to improve the performance of Aggregate transformation?

Dmss,

3 9241




What is critical mapping?

2 7215

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

Accenture,

1 14518

How to view and Generate Metadata Reports?

1 4877

what is difference between COM & DCOM?

Satyam,

1 8309

what is the gap analysis?

1 6430

How to recover sessions in concurrent batches?

3 11095

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

TCS,

3 19380


Post New Informatica Questions






Un-Answered Questions { Informatica }

if we have a delimiters at unwanted places in a flat file how can we over come those.

896


Design time, run time. If you don't create parameter what will happen

731


what is INFORMATICA TESTING process

1085


pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

173


Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

5969






explain abt ur project architecture?

1014


In what scenario we use to improve session performance by pushdown optimization?can any one give example?

3705


Reusable transformation and shortcut differences

645


what is the -ve test case in your project.

1069


how we can load rejected record's at run time?(not through bad files)

1121


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

854


wat are deployement groups in informatica, how it will be used for developers

651


What are session parameters ? How do you set them?

600


source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

1545


What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

519