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

Informatica Interview Questions

Questions Answers Views Company eMail

1) Alternative to update strategy transformation 2) out of 1000 records after loading 200 records, the session got failed. how do u load the rest of records ?? 3) use of lookup override

IBM,

3 10447

What r the type of indexes u generally used in informatica?

Keane India Ltd,

2 18859

What is the query to find nth highest salary? What is the use of cursors?

Keane India Ltd,

8 20948

explain about lookup t/r?

IBM,

1 4246

explain abt joiner t/r?

IBM,

1 4011

explain abt union t/r?

IBM,

1 4444

explain abt ur project architecture?

Anthem, DELL, IBM, TCS, Wipro,

2132

how do u fnd the duplicate rows and how to delete the duplicate rows?

IBM,

2 8200

source table have 3 records? and it is sucessfully loaded into target. and 4more records is added in to source .that means 7 records now in source. we have to load the remaining 4 records into the same trgt table with maintian top 3 records. how ?can any one give me the data flow of this logic plz?

Wipro,

5 10812

source table have single column single record having with single space. load that source record into trg . trgt having two columns and the SOURCE TABLE LIKE COL1 BHANU PRASAD TRGT TABLE COL1 COL2 IN THAT LOAD THE RECORD IN THE trgt table LIKE COL1 COL2 BHANU PRASAD HOW ? TELL ME PLZ

Wipro,

2 6315

what is the significance of newlookup port in dynamic look up

IBM,

1 6273

how many ways can we implement SCD2?

IBM, TCS,

4 15675

How many joins in Informatica

CSC,

5 23877

How to identify this row for insert and this row for update in dynamic lookup cache

CSC,

3 9348

What is router transformation

CSC,

4 6975

Post New Informatica Questions

Un-Answered Questions { Informatica }

If informatica has its scheduler why using third party scheduler?

1213

What is the sql query overwrite in source qualifier in informatica

1044

What is an Integration service in Informatica?

1094

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

2067

How to configure mapping in informatica?

1134

What are session parameters ? How do you set them?

1792

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

1987

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

1040

Different qualification between a related rotate toward the sky and isolates look upward?

948

Explain joiner transformation in informatica

1088

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

1102

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2370

Under what conditions selecting sorted input in aggregator will still not boost session performance?

1045

What do you mean by channel change?

986

How can we use batches?

979

For More Un-Answered { Informatica } Questions Click Here