from Source 100 rows are coming, on target there are 5 m rows which options is

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

Question Posted / achoudhr

21 Answers
40665 Views
Deloitte, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / srinu

Static Lookup on TARGET

Is This Answer Correct ?

1 Yes

6 No

Post New Answer

More Informatica Interview Questions

following scenario i have 1000 record flatfile source i want ist row to ist target 2nd eow to 2nd target 3rd row to 3rd target how will u do?

7 Answers Polaris,

What is the sequence generator transformation in informatica?

0 Answers

tell me some dimension tables names in banking domain informatica project(dont tell like depends on project, tell me names of dimension and fact table names in your project)?

3 Answers IBM, Patni, TCS,

What are the types of maping in Getting Started Wizard?

1 Answers

How do you Merge multiple Flat files for example 100 flat files with out using Union T/F

4 Answers IBM,

How to update records in Target, without using Update Strategy?

3 Answers

How can we use mapping variables in informatica? Where do we use them?

0 Answers

How to improve the session performance in informatica?

3 Answers Accenture,

Can we override a native sql query within informatica?

0 Answers

In CSV flat file date are in the following format. dd/mm/yyyy (05/01/2005)and d/m/yyyy (5/1/2005) and dd/m/yyyy (05/1/2005) and d/mm/yyyy (5/01/2005). It should be load to target in a unique format. How will you implement this?

1 Answers

i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time

3 Answers iGate,

Why we use partitioning the session in informatica?

2 Answers

For more Informatica Interview Questions Click Here