Informatica and IICS Real Time Project, Interview Question and Answers - 6

3. How many mapping have you created all together in your project?
I did over 35+ mappings, around 10+ were complex mappings.

4. In which account does your Project Fall?

hope its manufacturing and advanced services.
5. What is your Reporting Hierarchy?
me --team lead---Project Manager---programming Manager
me--- AR---HR
6. How many Complex Mapping’s have you created? Could you please me the situation for which you have developed that Complex mapping?

i think 8 , one for character by character comparision (with informatica not possible) so written 950 lines if single SQL code. and one for Dynamical Hierarchy distribution .... and one for Multi byte characters ( japanes,chines,..etc) and so on…

7. What is your Involvement in Performance tuning of your Project?
some times any way performance team will take care of my code

8. What is the Schema of your Project? And why did you opt for that particular schema?
some_Prd ---that is the souce for us

9. What are your Roles in this project?
as a developer , desing the workflows , unit testing, and so on...

10. Can I have one situation which you have adopted by which performance has improved dramatically?
yes ..... my first project ..i faced performance issue after go live.

11. Where you Involved in more than two projects simultaneously?

of couse ,, i involved 3 projects at a time.

12. Do you have any experience in the Production support?
yes/no

13. What kinds of Testing have you done on your Project (Unit or Integration or System or UAT)? And Enhancement’s were done after testing?
Unit testing and sometimes integration. UAT will done by business not BI team.

14. How many Dimension Table are there in your Project and how are they linked to the fact table?
current project 18 and 2 facts . and relationship will always be dimention keys.

15. How do we do the Fact Load?
after dimension load complete ..


16. How did you implement CDC in your project?
It is always on souce modification date.

17. How does your Mapping in File to Load look like?

souce ---ods---flat file ( .dat) -- e cap delimeter

18. How does your Mapping in Load to Stage look like?

is depends on project ...
Souce --ods---stage


19. How does your Mapping in Stage to ODS look like?

Stage to ods ???
never …
20. What is the size of your Data warehouse?
40 TB
21. What is your Daily feed size and weekly feed size?

22. Which Approach (Top down or Bottom Up) was used in building your project?

Bottom up ---i mean you are asking about dimention to fact and fact to dimention??

23. How do you access your source’s (are they Flat files or Relational)?
Relational and some times flat files also

24. Have you developed any Stored Procedure or triggers in this project? How did you use them and in which situation?

no

25. Did your Project go live? What are the issues that you have faced while moving your project from the Test Environment to the Production Environment?
yeah...i faced some issues.


26. What is the biggest Challenge that you encountered in this project?

Dynamic hierarchy data distribution and moving the files from unix box to informatica directory through shell script , need to clean the data in flat file itself.

27. What is the scheduler tool you have used in this project? How did you schedule jobs using it?
Dollar Universe.. by using $U Sessioin task.
informatica interview preparation,informatica interview scenarios,informatica interview questions,informatica interview videos,informatica interview,informatica admin interview questions,informatica interview tips,informatica interview questions and answers,informatica powercenter interview questions,technical interview questions,informatica questions,informatica training,informatica answers,informatica powercenter,informatica tutorial

informatica intelligent cloud services, iics informatica tutorial, iics to cloud data base connection, iics data integration tutorial, iics cloud data integration services, iics training informatica, iics tutorial for beginners, iics informatica tutorial telugu, iics informatica, iics informatica interview questions, iics informatica resume, iics informatica training, iics data integration, iics data integration interview questions, what is informatica iics, iics login issue, informatica intelligent cloud services, iics, iics Informatica Cloud secure agent
informatica or IICS interview question and answers for 2 years experience
informatica or IICS interview question and answers for 3 years experience
informatica or IICS interview question and answers for 4 years experience
informatica or IICS interview question and answers for 5 years experience
informatica or IICS interview question and answers for 6 years experience
Interview Question and answers of Informatica power center or IICS