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:

No Discussion on this question yet!

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:

No Discussion on this question yet!

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