Informatica Interview Questions

Informatica Interview Questions those I faced...

-- hari in ibm, praveen plsql in accenture

1) what are the conditions we required to join two tables?
2) how did you schedule your workflow ? did you used any tool?
3) Do you know SCD type IV
4) What is Mapplet?
5) What is Mapping ?
6) Diff between Mapplet & Mapping ?
7) Did you wrote any Procedures in your Project ? what reason ?
8) what type of testings you have done?
9) what is session?
10) explain you project?
11) what is a view? types ?
12) what is the diff between procedure ,function, package
13) why we are using (in, out, inout) in procedure?
14) while using lookup we need to change the lookup condition repeatedly...but it won't allows     you what is the probelm guess?
15) some questions on sequence genarator?
16) diff between OLTP OLAP
17) how to generate sequence no with out using sequence generator?
18) What you have done in your project ?
19) why u are interested in plsql job bcoz you have etl exp ?
20) diff between functions and procedure & packages ?
22) what is trigger where you used in project ?
24) have you used exception handling in your project what purpose ?


-- praveen in capgemini 2nd round for informatica

sql
---
18) diff between truncate,drop,delete
19) can we do insert and update at a time
20) what is trigger


unix
----
21) how to get only top row?
22) how to get 51-60 records?
23) how to load last 10 records?
24) what is GREP,SED
25) shell program to add two numbers

informatica
-----------
26) update strategy types(DD_update,DD_insert,DD_DELETE,D_REJECT)
27) without update strategy can we update the target
28) lookup cache, types of cache, difference's between cache's?
29) Normalizer transformation why it is using
30) DATAMART,DATAWAREHOUSE differences?
31) what is tracing?
32) what is target load ordering?
33) constraint base loading?
34) conncted,unconnected lookup diff? how you can call unconnected lookup?
35) what are the transformations you used in your project?
36) tell me about your role, responcibilities in project ?and tell me about your self?
37) how many dimension,fact tables are there in your project?

-- praveen in capgemini 3rd round hp client round:-

1) in a router t/f having 2 groups and conitioned sal >= 2000 for first group & sal <= 2000 for  second group what hapen when we run the mapping..
2) create a trigger for select statement
3) how did you done validation in your project ?
4) what is the order of port's exicution
5) difference between dynamic and lookup cache ?
6) what you have done for performence increase in your mapping ?
7) how did you validate the source & target data in case of testing ?
8) scenario : you have set treat source as " update "
              and used update else insert in session level
              what happens?

I've said it will update if match found other wise it will insert

9) how can you match the data if you are not using lookup t/f?
10) what is persistence cache ?
11) i have 100 flatfiles of same structure. how can i load all at a time ?
ans:- indirect loading using parameter file and paths

12) push down optimisation
13) have you done partitioning
14) what is paralalisim

-- praveen in capgemini 4th round hp client round:-

1.have you worked with xml files?
2.what is rowid,  and how you workout this in both mysql and oracle?
3.did you worked on partitioning?
4.what is batch
5.what type of files you used
6.what is pushdown
7.how to remove duplicate records
8.what is factless fact tables?
9.how to load first max sal,2nd max sal to target?
10.scenario: simple mapping if match found update else insert and without update strategy  t/f

-- praveen ust global questions:-

1) tell me about your project
2) can we update a target flat file with update t/f?
3) what are the target types we can update?
4) with out update strategy can we update target?
5) which tables we do load first dimensions or fact's?

-- icreative telephonic

1.can we join a meterialized view and a table?
2.structure of a stored procedure?
3.did you think that you done any thing that cant done by other's?
4.did you faced any complexity in your project?
5.what is tablespace?
6.what are the query types are there? //subquery,inline query,simple query,corelated subquery,
7.diff between inline and subquery?
8.what are the types of subqueries?
9.difference between having and where?
10.types of triggers,corsurs?
11.what is source qualifer tf?