Informatica Interview Questions for experience persons

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

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.