Informatica Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Informatica Interview Questions

Questions Answers Views Company eMail

What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.

Zensar,

1 7246

How you count the number of records available at your source?

Zensar,

3 14495

How you load distinct records into one target and duplicate records into another target?

Mphasis,

3 16807

Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me

HP,

5 11594

write a query to get maximum salary from the employers table without duplicates....kindly help me

CTS,

5 10247

Hi experts, table 1 has 10 records, table 2 has 5 records select * from table1, table2; What is the output for this query???....plz answer

TCS,

3 7378

hi talents, how do u get sequece numbers with oracle sequence generator function in informatica.... i dont need to use sequence generator transformation..... how do u achieve this???

HP,

3 9207

What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort

Qwest,

1 5952

Hi Experts, Performance Wise Which transformation is better in LOOKUP AND JOINER TRansformations? Why? Can anybody please explain it ? Please help me out from this Question. Thanks In Advance.

CTS,

2 14106

HI Experts, What is BULK mode and NORMAL mode, Which one gives better performance. How? Please Explain with an example...! It will help's me a lot. Thanks In advance.

CTS,

8 15275

HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND LOOKUP?

Cap Gemini,

11 32321

i have a source table ID NAME SAL 101 A 1000 102 B 2000 103 C 1500 target load should be ID NAME SAL 101 A 1000 101 B 2000 101 C 1500 102 A 1000 102 B 2000 102 C 1500 103 A 1000 103 B 2000 103 C 1500

TCS,

3 6601

By seeing the parameter file how do u identify wheather it is a workflow parameter or mapping parameter?

Keane India Ltd,

5 9361

What are the different caches used in informatica?

UST,

3 7383

If u r giving different parameter file names in workflow and session for a single mapping parameter, then which one will be executed? The one u given in workflow or the one u given in the session?

Hexaware,

1 6796

Post New Informatica Questions

Un-Answered Questions { Informatica }

Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

2100

Which are the different editions of informatica powercenter that are available?

1084

How can we use batches?

1066

What is informatica powercenter repository?

1262

What are the new features of informatica 9.x in developer level?

1055

What are the different components of powercenter?

1119

What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

2412

How do you promote a non-reusable transformation to reusable transformation?

1188

Difference between Data and Index Caches?

1209

What is a sorter transformation?

1160

What are the designer tools for creating transformations?

1160

permutations of mapplet

2551

What is the difference between a connected look up and unconnected lookup?

1005

What is the use of target designer?

1123

What is a repository? And how to add it in an informatica client?

1196

For More Un-Answered { Informatica } Questions Click Here