✍ Kashif M ™
☎ +91 9994883085
✉ kashif7222@gmail.com


Saturday, 7 June 2014

Informatica Interview Questions For Experienced

By on June 07, 2014

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

mkashu: Informatica Interview Questions For Experienced
Review : Kashif | Kashif
Update: June 07, 2014 | Rating: 4.5

Comment for "Informatica Interview Questions For Experienced"


  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).

  2. hi sir, post answers for the questions


Blog Archive