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 7148

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

Zensar,

3 14339

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

Mphasis,

3 16623

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 11402

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

CTS,

5 10059

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 7258

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 9060

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 5888

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 13979

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 14957

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

Cap Gemini,

11 31939

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 6446

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

Keane India Ltd,

5 9147

What are the different caches used in informatica?

UST,

3 7230

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 6666

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is meant by lookup transformation? Explain the types of lookup transformation?

947

Explain dynamic target flat file name generation in informatica

1052

What is transformation?

1099

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

1058

Explain the shared cache and re-cache?

1113

How many ways are there to do 'remove duplicate records in informatica'?

1014

What are the tasks that can be performed using sq?

1091

What is the cumulative sum and moving sum?

1186

What could be the possible resons of locks by user?

1091

What is the need for an etl tool?

1068

What are the data movement modes in informatica?

1152

What is a mapplet/worklet in informatica?

1185

How to extract sap data using informatica? What is abap? What are idocs?

1181

How to join three sources using joiner? Explain though mapping flow.

1147

What is an expression transformation in informatica?

1037

For More Un-Answered { Informatica } Questions Click Here