Informatica Interview Questions
Questions Answers Views Company eMail

what is lookup ?

6 4160

what is the architecture of any Data warehousing project?

IBM,

4 7828

what is the flow?

1 1907

How to load time dimension?

Ford,

1 6594

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

5 10930

How do you create single lookup transformation using multiple tables?

TCS,

6 19720

Why touse stored procedure in ETL Application?

2 4935

How to improve the performance of Aggregate transformation?

Dmss,

3 5904

What is critical mapping?

1 4297

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

Accenture,

1 10189

How to view and Generate Metadata Reports?

1 2501

what is difference between COM & DCOM?

Satyam,

1 5997

what is the gap analysis?

1 4279

How to recover sessions in concurrent batches?

3 7519

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

TCS,

3 14878


Post New Informatica Questions


Un-Answered Questions { Informatica }

Differences between version 7.x and 8.x.

300


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

419


Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

980


In development project what is the process to follow for an etl developer from day1

88


how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

2928


I HAVE A TEXT FILE NAME X WITH A TEXT MESSAGE. WORD INFORMATICA IS REPEATED FOR N NUMBER OF TIMES. HOW TO COUNT THE NUMBER OF OCCURANCE OF WORD INFORMATICA OF WORD INFORMATIC IN THIS FILE X.

817


How will you convert rows into columns or columns into rows

199


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

2295


How u use pdf file in informatica source?

3445


Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

456


What is the meaning of up gradation of repository?

259


how to load the data in fact table.. using look up transformation how to view the second record. usally look up shows matching record for only one value. if i have same value its not displaying. ex: problem i faced. i have total, student no and name in table student i used aggregation transformation to display max(total). i have two same max values in total. when i look up the student name and no for this max(total), its showing only one name and no, its leaving the second one. how to rectify it. plz tel me step by step or clearly.

2217


explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

675


What are variable ports and list two situations when they can be used?

330


can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

1090