Technical Interview Questions and Answers :: Informatica

Home > Technical Interview Q&A > Informatica > Q & A

Upcoming !!!

61 / 94

What is a persistent cache?

View Answer| Post Your Answer | my reading list

To Reading List | tag

Asked In

Answer:

The persistent cache in lookup transformation behaves as the cache is utilized again in the same workflow(mapping) execution on again and again.

The Integration Service saves or deletes lookup cache files after a successful session run based on whether the Lookup cache is checked as persistent or not.

Please Login First :

62 / 94

What is a shared cache?

View Answer| Post Your Answer | my reading list

To Reading List | tag

Asked In

Answer:

No Discussion on this question yet!

Please Login First :

63 / 94

What is unnamed cache and named cache?

View Answer| Post Your Answer | my reading list

To Reading List | tag

Asked In

Answer:

No Discussion on this question yet!

Please Login First :

64 / 94

How do you improve the performance of lookup transformation?

View Answer| Post Your Answer | my reading list

To Reading List | tag

Asked In

Answer:

If the lookup table is on the same database as the source table in your mapping and caching is not feasible, join the tables in the source database rather than using a Lookup transformation.

If you use a Lookup transformation, perform the following tasks to increase performance:

Use the optimal database driver.

Cache lookup tables.

Optimize the lookup condition.

Filter lookup rows.

Index the lookup table.

Optimize multiple lookups.

Create a pipeline Lookup transformation and configure partitions in the pipeline that builds the lookup source.

Please Login First :

65 / 94

How do you remove Duplicate records in Informatica? And how many ways are there to do it?

View Answer| Post Your Answer | my reading list

To Reading List | tag

Asked In

Answer:

IN INFORMATICA TO REMOVE DUPLICATE RECORDS BY USING

FIRST WAY IS

USING SOURCE QUALIFIER TRANSFORMATION CLICK ON PROPERTIES AND SELECT DISTINCT PROPERTY THEN YOU WILL REMOVE DUPLICATE RECORDS.

BY USING SOURCE QUALIFIER YOU CAN OVERRIDE THE SQL QUERY YOU CAN REMOVE DUPLICATE RECORDS BUT IT IS WORKING ONLY FOR DATA BASE SOURCE NOT WORKING FOR FLAT FILES.

SECOND WAY:

IN SORTER TRANSFORMATION ALSO YOU CAN CLICK ON PROPERTIES TAB SELECT DISTINCT PROPERTY THIS SCENARIO ALSO WORKING TO REMOVE DUPLICATE RECORDS.

THIRD WAY:

Please Login First :

66 / 94

Differentiate between Source Qualifier and Filter Transformation?

View Answer| Post Your Answer | my reading list

To Reading List | tag

Asked In

Answer:

No Discussion on this question yet!

Please Login First :

67 / 94

What are the differences between Source Qualifier and Joiner Transformation?

View Answer| Post Your Answer | my reading list

To Reading List | tag

Asked In

Answer:

No Discussion on this question yet!

Please Login First :

68 / 94

Differentiate between joiner and LookupTransformation.

View Answer| Post Your Answer | my reading list

To Reading List | tag

Asked In

Answer:

Join Transformation	Lookup Transformation
It uses only = operator to match column data. It has four type of joiner : Normal join master outer join detail outer join Full outer join	It uses =,>=,<=, != operator. It work like Left outer join only.
Joiner is active and connected transformation	Lookup is active/passive and connected or unconnected transformation.
Joiner transformation is used to usually to join data coming from two separate tables or source qualifiers.	Look up transformation can be used on a single table or a query to search for records that match incoming Records