Skip to main content

Informatica Interview Questions For Experienced




Informatica Interview Questions!!!!!!! Informatica Interview Questions!!!!!!!!!!!!!!!


1 Active/passive transformation (Lookup /sorted active or passive


2 When you connect to repository for the first time it asks you for user name & password of repository and database both.


3 why lookup is connected


4 Can a joiner be used in a mapplet.


5 What are active transformations.


6 Repository user profiles


7 explain what details we get in workflow log


8 How do u set a varible in incremental aggregation


9 Global and Local shortcuts. Advantages.


10 differnce between parameter and varaible


11 How can you use an Oracle sequences in Informatica? You have an Informatica sequence generator transformation also. Which one is better to use?


12 what is reporting tool used informatica


13 Sequence generator, when u move from develoment to production how will u reset


14 bulk/normal mode (when we will go for it


15 How to run a session, which contains mapplet?


16 How do u recover rows from a failed session


17 Why use shortcuts(Instead of making copies


18 What are the new features of Power Center 5.0?


19 Slowly changing dimensions, types and where will you use them


20 Do u have knowledge in ralph kimball methodology


21 what is target/source override


22 SCD type 2, how to achive, how to update exisitng record


23 When do u use mapping parameters? (In which transformations


24 How do u implement unconn. Stored proc. In a mapping?


25 Whats there in global repository


26 In a concurrent batch if a session fails, can u start again from that session


27 what is concurrent work flow, how to achive?


28 How big was your fact table


29 What are conformed dimensions?


30 What are the modules in Power Center


31 How do you implement scheduling in Informatica?


32 where is the reject loader .


33 What did u do in source pre load stored procedure


34 Implementation methodology


35 differnce between lookup and joiner


36 When will you use SQL override in a lookup transformation?


37 connected/unconnected tranformation


38 Can u use flat files in Mapplets.


39 Can u create a flatfile target


40 What is a test load?


41 what peristant cache, how to get latest data using persitant cache, what details will contain in cache file


42 Session Recovery. 1000 rows in the source of which 500 passed through and then I killed the session. Can you perform a recovery and how


43 How do you use reject loader.


44 what is the meaning of complex transformation?


45 Where do u create/define mapping parameter and mapping variable?


46 what DTM buffer size


47 disable caching in a lookup transformation?


48 dependency of session (if one session fails will it continue next?


49 Do u have to change the reject file b4 using reject loader utility.


50 Have you worked with/created Parameter file


51 What is the meaning of up gradation of repository?


52 10k record in source and insert 10k in target (which mode we need to use?


53 in any project how many mappings they will use(minimum


54 Parttion, what is pass throgh parttion


55 What happens if the info. Server doesn’t find the session parameter in the parameter file?


56 How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.


57 What's the restriction for Pushdown optimization, can we use aggregator pushdown optimization


58 What are variable ports and list two situations when they can be used?


59 What are active transformations? Name them.


60 How does the session recovery work.


61 How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target


62 How to pass value to un connected stored procedure


63 How will u convert rows into columns or columns into rows


64 in Router without any condition, which group it will get oputput


65 schema type, start schema can we have more than 1 fact


66 if we have 5core record ,is it better to use bulk or normal mode


67 Partition, what happens if the specified key range is shorter n longer


68 can we have lookup on file (source is file


69 what is the basic difference in these two setups and which is recommended?


70 what is rank transformation


71 How do you do error handling in Informatica?


72 What are session parameters ? How do u set them?


73 what is datawearhousr/why we need


74 What is the difference between sequential batch and concurrent batch and which is recommended and why?


75 How to check cache size


76 how to set no of rejection (more than 10 rejction


77 how achive update staergy without using tranformation update staergy


78 what are all new features in 9


79 What’s the layout of parameter file (what does a parameter file contain?


80 How can you run a session without using server manager?


81 Differences between version 7.x and 8.x.


82 what is mapplet, why we need it, can we have mapplet under mapplet


83 Why do u use Mapping Parameter and mapping variable?


84 What is the difference between normal and bulk loading?


85 What is a parameter When and where do u them when does the value will be created


86 Desing time, run time. If u don’t create parameter what will happen


87 Scheduling properties,whats the default (sequential


88 When u move from devel to prod how will u retain a variable


89 what is scd? explain scd3 ?


90 How does the server recognize the source and target databases. Elaborate on this.


91 can you avoid static cache in the lookup transformation? I mean can you


92 Differentiate between Load Manager and DTM?


93 explain Performance tuning achived in your project


94 what are factless facts? And in which scenario will you use such kinds of

fact tables.


95 What are Business Components in Informatica?


96 type of cache


97 pcmcd differnt parameter


98 what is source/target commit interval


99 what is ODs (differet type of storage


100 type of logs generate in informatica


101 session level optmziation (parameter set


102 Reusable transformation & shortcut differences


103 chekin/checkout (steps to taken care for checkout mapping


104 What are the main features of Oracle 8i with context to datawarehouse?


105 Which one is recommended?


106 What are the parts of Informatica Server?


107 type of datawarehouse


108 Can u access a repository created in previous version of Informatica?


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


110 Performance tuning( what u did in performance tuning


111 How many transformations can be used in mapplets.


112 How do you change parameter when u move it from development to production.


113 sql override


114 Why Union transformation is active


115 Debugger – what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.


116 What is mapplet and a reusable transformation?


117 How do you implement configuration management in Informatica?


118 What is the difference between a shortcut of an object and copy of an object?


119 Filter transformation in the condition one of the data is NULL would the record be dropped.


120 why Joiner is required, we can use in source qualifier (what are differnt join

Comments

  1. Hi sir nice collection. caan you please ppost thee answers for the above questions. Am learning informatica, can u send me some interview Q&A to my mail id(mahesh.katta7@gmail.com).

    ReplyDelete
  2. hi sir, post answers for the questions

    ReplyDelete

Post a Comment

Popular posts from this blog

Contact Me

Do You have any queries ?                   If you are having any query or wishing to get any type of help related Datawarehouse, OBIEE, OBIA, OAC then please e-email on below. I will reply to your email within 24 hrs. If I didn’t reply to you within 24 Hrs., Please be patience, I must be busy in some work. kashif7222@gmail.com

Top 130 SQL Interview Questions And Answers

1. Display the dept information from department table.   Select   *   from   dept; 2. Display the details of all employees   Select * from emp; 3. Display the name and job for all employees    Select ename ,job from emp; 4. Display name and salary for all employees.   Select ename   , sal   from emp;   5. Display employee number and total salary   for each employee. Select empno, sal+comm from emp; 6. Display employee name and annual salary for all employees.   Select empno,empname,12*sal+nvl(comm,0) annualsal from emp; 7. Display the names of all employees who are working in department number 10   Select ename from emp where deptno=10; 8. Display the names of all employees working as   clerks and drawing a salary more than 3000   Select ename from emp where job=’clerk’and sal>3000; 9. Display employee number and names for employees who earn commission   Select empno,ename from emp where comm is not null and comm>0. 10

Informatica sample project

Informatica sample project - 1 CareFirst – Blue Cross Blue Shield, Maryland (April 2009 – Current) Senior ETL Developer/Lead Model Office DWH Implementation (April 2009 – Current) CareFirst Blue Cross Blue Shield is one of the leading health care insurance provided in Atlantic region of United States covering Maryland, Delaware and Washington DC. Model Office project was built to create data warehouse for multiple subject areas including Members, Claims, and Revenue etc. The project was to provide data into EDM and to third party vendor (Verisk) to develop cubes based on data provided into EDM. I was responsible for analyzing source systems data, designing and developing ETL mappings. I was also responsible for coordinating testing with analysts and users. Responsibilities: ·          Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business. ·          Understood the requirement and develope