Oracle Business Intelligence Application Architect
☎ +91 9994883085
Don't miss

Sunday, 2 November 2014

Informatica Interview Questions for experience persons


By on 09:24:00


Informatica Interview Questions for experience persons,  prepared by - Kashif M



1 How will you know the job running is executed successfully or not?
2 Where can you find the error ? After finding the erro what will be the steps which you wil follow for removing any error?
 
3 Biggest problem u faced while developing the project.
 
4 What is the difference between STOP & ABORT?
 
5 How DTM Buffer Size & Buffer Block Size are related?
 
6 What are the output files that the Informatica Server Creates during the session run?
 
7 Why Union transformation is active
 
Informatica Interview Questions for experience persons
Informatica Interview Questions for experience persons
8 What's the restriction for Pushdown optimization, can we use aggregator pushdown optimization
 
9 why Joiner is required, we can use in source qualifier (what are differnt join)
 
10 How to pass value to un connected stored procedure
 
11 in Router without any condition, which group it will get oputput
 
12 SCD type 2, how to achive, how to update exisitng record
 
13 Parttion, what is pass throgh parttion
 
14 explain Performance tuning achived in your project
 
15 what DTM buffer size
 
16 How to check cache size
 
17 what peristant cache, how to get latest data using persitant cache, what details will contain in cache file
 
18 what is target/source override
 
19 what are all new features in 9
 
20 differnce between lookup and joiner
 
21 what is source/target commit interval
 
22 what is concurrent work flow, how to achive?
 
23 chekin/checkout (steps to taken care for checkout mapping)
 
24 why lookup is connected in 9
 
25 what is reporting tool used informatica
 
26 What was the flow of your project?
 
27 Which kind of mapping you have worked on?
 
28 Which scheduling tool you used in your Project?
 
29 How to schedule a job?
 
30 Regarding UNIX commands?
 
31 What was the Complex mapping in which you got stucked or which took more time?
 
32 How are you generating Serrogate key in your mappings?
 
33 What are you using for joining tables in your project Joiner or Lookup and why?
 
34 How are you doing Incremental Aggregation?
 
35 How are you generating Parameters?
 
36 How will you access a flat file which is not in Informatica server location?
 
37 Does informatica recognizes Excel data (Ext .XLS not .csv ) as flat file or Table and how can we fetch excel data?
 
38 "what is remote file name and what is its significance in flat file laoding.
 
39 what is the easy way of debugging a flat file which have say 1000 records and problem is around 413 record.
 
40 Is look up active or passive and how? ( From 9.1 onwords it is active !!!)
 
41 "I have created a a reusable sequence generator can i demote it to Non- Reusable? what is the significance of CYCLE property in sequence generator...if i disabled that what is the problem?"
42 We have 3 pipelines each one contains 10 rows out of which 3 rows from each of the pipelines have same values. Can we remove duplicates and load unique set using Union transformation ? what is the process?
 
43 How many ports can i make as rank and is it possible to fetch top 4th to 13 th ranked employees based on condition?
 
44 I have 3 rows in the Source field1 as A,B and C.I specified in the router 4 conditions Field1=A , Field1=A OR B ,Field1=A OR C and Field1= B OR C. How many rows will be loaded in to target.


Set - 2

1) Is Transformed data is stored in repository or database
 
2) can the staging databse can be flat files
 
3) how often load data to Warehouse
 
4)how many connected stored procedures,unconnected
 
5)can a company contains more than 1 datawarehouse
 
6)how many universe u developed in ur project(Business Objects), name them?
 
7)Architecture of datawarehouse
 
8)At what position od DW you have involved
 
9)how many tables can be in staging DB and also how many in the source DB
anyhow u may not know these info correct that how many
tables but in general tell me the number.
 
10) how many intermediate tables u created from Source
 
11) what r the stored procedures can be used in any
 
12) DW project Lifecycle?
 
13) which database you will use as DWH database Oracle 10g,Teradata V2R5, Informix.
 
14) Which ETL tool you will use for your DWH purpose and why?



Set - 3

1. How will you access a flat file which is not in Informatica server location?
 
2. Does informatica recognizes Excel data (Ext .XLS not .csv ) as flat file or Table and how can we fetch excel data?
 
3. what is remote file name and what is its significance in flat file laoding.
 
4. what is the easy way of debugging a flat file which have say 1000 records and problem is around 413 record.
 
5. Is look up active or passive and how? ( From 9.1 onwords it is active !!!)
 
6. I have created a a reusable sequence generator can i demote it to Non- Reusable? what is the significance of CYCLE property in sequence generator...if i disabled that what is the problem?"
 
7. We have 3 pipelines each one contains 10 rows out of which 3 rows from each of the pipelines have same values. Can we remove duplicates and load unique set using Union transformation ? what is the process?
 
8. How many ports can i make as rank and is it possible to fetch top 4th to 13 th ranked employees based on condition?
 
9. I have 3 rows in the Source field1 as A,B and C.I specified in the router 4 conditions Field1=A , Field1=A OR B ,Field1=A OR C and Field1= B OR C. How many rows will be loaded in to target.

0 comments:

Post a Comment

Blog Archive

Labels

1z0-482 Dumps (2) 1Z0-525 Dumps (1) BI Apps Installation (1) BI Publisher Interview Questions (1) BICS (2) Business Intelligence (1) DATA WAREHOUSE ADMINISTRATOR CONSOLE (18) Data Warehousing (48) E-BIZ R12 (1) E-BIZ R12 INSTALLATION (1) Essbase (1) hmailserver (1) Hyperion (1) Hyperion Essbase (2) Hyperion Essbase Interview Questions (1) Hyperion financial management (1) Informatica (163) Informatica Installation 9.6.1 (2) Informatica Interview Question (47) Informatica Online Training (1) informatica scenarios questions (1) Informatica Training (1) Informatica Training Chennai (1) JAVA (1) linux (1) Normalization in Oracle (1) OBIA 11.1.1.7.1 (1) OBIA 7.9.6.3 (3) OBIA Installation (33) OBIEE (2) OBIEE 10G (8) OBIEE 11G (138) OBIEE 11g dumps (2) OBIEE 11g Interview Questions (1) OBIEE 12c (20) OBIEE 12c Architecture (1) OBIEE 12C TRAINING (1) OBIEE certification (2) OBIEE Interview Question (1) OBIEE Publisher Interview Questions (1) OBIEE TRAINING CHENNAI (1) OBIEE TRAINING ONLINE (1) ODI (Oracle data integrator) (2) odi 11g certification (1) ODI dumps (2) Oracle Administrator (20) Oracle Business Intelligence Application (3) Oracle Data Integrator (2) Oracle Data Integrator Interview questions for experience (1) Oracle Database (3) Oracle Database 12c Installation steps (3) Oracle Database Installation in Linux 6 (2) Oracle E-Business R 12.3 (1) Oracle Hyperion Planning and Budgeting Questionnaire (2) oracle Joins (1) Power BI (5) RCU INSTALLATION (1) scorecard in obiee 11g (1) SQL (3) SQL Interview Questions (1) sql server 2008 (2) Sql server installation (1) WinSCP (1)