Informatica Interview Questions
Questions Answers Views Company eMail

what is lookup ?

6 5013

what is the architecture of any Data warehousing project?

IBM,

4 8707

what is the flow?

1 2323

How to load time dimension?

Ford,

1 7383

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

7 12110

How do you create single lookup transformation using multiple tables?

TCS,

6 21383

Why touse stored procedure in ETL Application?

2 5530

How to improve the performance of Aggregate transformation?

Dmss,

3 6385

What is critical mapping?

1 4703

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

Accenture,

1 10822

How to view and Generate Metadata Reports?

1 2937

what is difference between COM & DCOM?

Satyam,

1 6418

what is the gap analysis?

1 4660

How to recover sessions in concurrent batches?

3 8108

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

TCS,

3 15601


Post New Informatica Questions


Un-Answered Questions { Informatica }

Is there any target staging area in informatica not staging area

1046


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,

4299


Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

567


In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

418


What are the modules in Power Center

275


In which scenario did you used pushdown optimization?

647


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

437


what is the size of u r source(like file or table)?

684


1. When u r checking out what ll happens for version no? a. Increase b. decrease c.reset to 0 d. reset to 1 e. no change 2. Salary of all employees needed to add with the commision. What transfrmation to be used? a. SQ and Expression b. SQ c. Update Strategy d. Expression 3. Which of the task is used to run a session based on success of the other session? a. Decision b. Event wait c. Email d. Command e. None 4. Types of sources in Informatica? a. Homogenous n Heterogenous b. None c. Cobol n XML d. Flat files e. Flat files and Homogenous n Heterogenous 5. Servers are available in informatica? a. Informatica Server and Workflow server b. Informatica Server and Informatica Repository Server c. Informatica Server d. Workflow server e. Informatica Repository Server 6. While using Pmcmd in cmd line mode, each command must include the connection info of which of the following? a. workflow manager b. Power Center server c. Workflow monitor d. Repository manager e. Designer 7. Workflow montior displays workflows that have run a. once b. twice c. never d.four times e. thrice 8. Mode for handling sessions n workflows? a. server mode b. Wait mode c. Command line mode d. User mode e. Interactive mode 9. Connection details configured in? a. Mapping designer b. Workflow manager c. Workflow monitor d. Repository manager e. Worklet designer Thanks in Advance

2469


What are the main features of Oracle 8i with context to datawarehouse?

266


have u done any performance tuning? how u ll do?

773


my source is junk data how will u remove that junk data by using unix please any one replay me

2088


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

3926


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.

1006


What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

3719