from Source 100 rows are coming, on target there are 5 m
rows which options is better to match data

1. Joiner
2 No cache
3. Static
4. Dynamic

Answer Posted / vijaykumar

Answer 7# is wrong because here we have only 1 source. It is
correct in case of 2 sources.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different types of transformation available in informatica.

622


Explain the etl program with few examples.

537


what is degenerated dimension?

3138


Enlist the various types of transformations.

546


How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

700






Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

1608


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

636


whats the logic to load the lower level of granularity of data to fact table.

1789


How many transformations can be used in mapplets.

1443


What is a surrogate key?

554


To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

665


Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

624


What is the Process to creating lookup transformation in informatica

574


Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1440


What is different between the data warehouse and data mart?

620