Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Informatica Interview Questions
Questions Answers Views Company eMail

What is hash partition?

2 8493

How can you define a transformation? What are different types of transformations in Informatica?

10 25569

What is query panel?

1 5614

What is a look up function? What is default transformation for the look up function?

ASM, TCS,

2 17186

What is difference between a connected look up and unconnected look up?

6 25762

What is staging area?

11 27010

What is data merging, data cleansing and sampling?

Satyam,

6 22988

What is up date strategy and what are the options for update strategy?

2 10395

Why do we use DSS database for OLAP tools?

2 6857

What is active and passive transformation?

10 41030

What is an MDDB? What is the difference between MDDBs and RDBMSs?

3 19776

How is Data Models Used in Practice?

1 5401

What is the difference between view and materialised view?

4 13086

What is data quality? How can a data quality solution be implemented into my informatica transformations, even internationally?

IBM, Wipro,

2 21408

What is the approximate size of data warehouse?

Accenture, i3 Solutions,

6 38379


Post New Informatica Questions

Un-Answered Questions { Informatica }

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

2038


How to update a particular record in target with out running whole workflow?

1584


What is a standalone command task?

1209


what is $$$$?

2163


What is union transformation in informatica?

1151


SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

2135


What are the steps involved in the migration from older version to newer version of Informatica Server?

2112


What are the basic requirements to join two sources in a source qualifier transformation using default join?

1134


can we override a native sql query within informatica? How do we do it?

1132


What are the differences between a connected lookup and unconnected lookup?

1071


How to extract the informatica rejected data?

1225


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

4198


How does a sorter cache works?

1075


How many transformations can be used in mapplets.

1940


How many input parameters can exist in an unconnected lookup?

1550