Informatica Interview questions

1. How to filter record's in an XML file SQ and how to change the datatype
2. How to load data into a table based on the column length ,i.e. variable length of data filled in the column

Retail Client interview questions 01/16/2012 Consulting Co.

1. How do you load data using informatica into tables with primary key - foreign key constraints enabled ?
2. If a workflow with many sessions is reported to be having load issues, what would be your approach to investigate these issues ?
3. How would you load data into tables with ragged hierarchies ? How do you query such tables using informatica ? What is the connect by prior clause in oracle? Would you be able to load these tables using the constraint based loading ?
4. What is an indirect file type in informatica? What are they used for?
5. How do you handle tables with many to many relationship? How do you load data into such tables with many to many relationship?
6. How do you ensure data integrity in oracle i.e. the underlying data is not modified, while executing DML statements in an oracle cursor?
7. What are some of the most difficult mappings or scenarios in Informatica ?
8. Have you used change data capture in Power exchange?
9. Which types of tables can be master or detail tables in informatica joiner? If two tables are large and equal sized which table will be a candidate for Master table in the joiner?
10. List some of the unix commands that you have used? What type of shell you have used?
11. What talend tools you have used ?

Informatica interview 01/19 Media Co.
1. What is the difference between EDM & MDM ?
2. How did you implement MDM ? What are the components of MDM ? How did you define the rules ?
3. What are the components of EDM ?
4. In oracle how would you represent the entire hierarchy of the organization?
5. If you face any issue in a new tool what would you do to resolve it ? where would you look for the issues ?
6. If you are introducing a new product in the Market and you want to derive your business strategy on how to target your sales , how would you design your systems ?
Product
Region/Country
Age group/Demographic distribution of the customers
Time
day level

Give some realtime scenarios

Interview questions on 01/19/2012 For the tools specialist

1. What is the transaction control transformation ?
2.What is the query analyzer in informatica?
3.Have you used Informatica velocity ?
4. Familiarity with DBMover and the Config file in PWX ?

Comments

Post a Comment

Popular posts from this blog

External Tables in Oracle 10g/11g Database: Part 1

http://www.packtpub.com/article/external-tables-oracle-10g-11g-database-part1 In this two-part article by Hector R. Madrid, we will learn about the External Tables in Oracle 10g/11g Database. When working in data warehouse environments, the Extraction—Transformation—Loading (ETL) cycle frequently requires the user to load information from external sources in plain file format, or perform data transfers among Oracle database in a proprietary format. This requires the user to create control files to perform the load. As the format of the source data regularly doesn't fit the one required by the Data Warehouse, a common practice is to create stage tables that load data into the database and create several queries that perform the transformation from this point on, to take the data to its final destination. A better approach, would be to perform this transformation 'on the fly' at load time. That is what External Tables are for. They are basically external files, managed either...
Read more
Image
Using Triggers and Compound Triggers in Oracle 11g By Contributing Author on June 16, 2011 in Database Development , Oracle Database In database terminology, triggers are the objects which demonstrate the logic of schedule and automation. Triggers are automatically invoked at a defined event and timing without any explicit calls. The logic embedded within the trigger and invocation must be well directed and synchronized to maintain database purity. Oracle 11g made remarkable enhancements in Database Triggers. These enhancements and additions have transformed triggers into a logical, stable, and comprehensive database platform. In the past versions, developers used to face issues under certain conditions as listed below. Multiple triggers for single timing Mutating table confrontation Control the trigger execution by enabling and disabling it Introduction of compound triggers which triggers different logic at different timings, guaranteed execution sequence of t...
Read more

Unix Commands - Advanced

Access Control exit - terminate a shell (see "man sh" or "man csh") logout - sign off; end session (C shell and bash shell only;) passwd - change login password rlogin - log in remotely to another UNIX system ssh - secure shell slogin - secure version of rlogin yppasswd - change login password in yellow pages Communications mail - send and receive mail mesg - permit or deny terminal messages and talk requests pine - send and receive mail talk - talk to another logged-in user write - write to another logged-in user Programming Tools as - assembler, specific to each machine architecture awk - pattern scanning and processing language bc - online calculator cc - C compiler csh - C shell command interpreter dbx - source-level debugging program f77 - Fortran compiler gdb - GNU Project debugger gprof - display profile of called routines kill - kill a process ld - the UNIX loader lex - generate lexical analysis programs lint - check C source code make - maintain l...
Read more