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 9437

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

Keane India Ltd,

2 17953

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

Keane India Ltd,

8 18758

explain about lookup t/r?

IBM,

1 3668

explain abt joiner t/r?

IBM,

1 3444

explain abt union t/r?

IBM,

1 3870

explain abt ur project architecture?

Anthem, DELL, IBM, TCS, Wipro,

1760

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

IBM,

2 7306

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 9192

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 5504

what is the significance of newlookup port in dynamic look up

IBM,

1 5493

how many ways can we implement SCD2?

IBM, TCS,

4 14409

How many joins in Informatica

CSC,

5 22386

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

CSC,

3 8305

What is router transformation

CSC,

4 5609


Post New Informatica Questions

Un-Answered Questions { Informatica }

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

645


What is the function of aggregator transformation?

574


Differentiate between source qualifier and filter transformation?

998


What is meant by LDAP users?

690


In development project what is the process to follow for an etl developer from day1

1278






What is the difference between informatics 7x and 8x and what is latest version?

540


Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

775


Please let me know how to make encryption and decryption with example?

1463


Design time, run time. If you don't create parameter what will happen

1424


I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1315


Do you find any difficulty while working with flat files as source and target?

670


What are the tuning techniques you applied during your last project

1560


How to call shell scripts from informatica?

573


What is enterprise data warehousing?

612


How to create a non-reusable instance of reusable transformations?

674