1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

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 / chitti

use joiner tr............
you have to take source as master table and target as detail
table

Is This Answer Correct ?    0 Yes 0 No

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

Answer / swapnil

It should be un chached coz by this way the 100 records
will directly compare at the database level hence no cache
will get created and will take less time not to create
cache and compare the source records at the db level.

Is This Answer Correct ?    0 Yes 0 No

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

Answer / achoudhr

But why Static at Target ?

Is This Answer Correct ?    1 Yes 2 No

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

Answer / kt

Coolboy answer is correct , if you just want to join.

When u want to update the target then we hsould use DYNAMIC
cache.

Is This Answer Correct ?    1 Yes 2 No

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

Answer / nani

5m in the sense five more rows.
based on the above,which post is good?

Is This Answer Correct ?    0 Yes 1 No

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

Answer / amarnath

using the joiner is right I have faced similar kind of
scenario in my project. if u use static it has to cache all
the 5m records and then compare the each incoming records
which will de-grade the performance, hence designate the
master record with less no of rows in joiner which is a gud
practice.

Is This Answer Correct ?    1 Yes 2 No

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

Answer / srinu

Joiner :- Catch Performance will work based on
Master,Detail Column,Data catch,Index
catch ,Catch Size also.
(Process Begins with Condition,Comparing, Indexing)

No Catch :-With out Catch, its not easy find(5 records)
Relavtive Data.

Static ;- Catch will Keep the Target Rows to Compare with
Sourece Rows.
(Process Begin with Condition,Comparing).

Dynamic :- The Catch Data will be Update on DataFlow
also. ,,,

Is This Answer Correct ?    2 Yes 4 No

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

Answer / kareem

we need to use dynamic lookup because when 110 rows are
coming from the source and 5 m rows are already existing in
the target here the function of the dynamic lookup is used
to share the source rows and insert into the target.

Hope answer your question.

Is This Answer Correct ?    4 Yes 6 No

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

Answer / sudhakatr.lake

Static

Is This Answer Correct ?    0 Yes 3 No

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

Answer / sri

Hi Sudhakatr.lake !

Why Static

Is This Answer Correct ?    0 Yes 4 No

Post New Answer

More Informatica Interview Questions

where to select code page option?

2 Answers   TCS,

Which means the first record should come as last record and last record should come as first record and load into the target file?

0 Answers   Informatica,

What is a code page in Informatica

3 Answers   American Express, Cognizant, Deloitte,

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

0 Answers  

i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c i want output as 1 a,b,c and 2 a,b,c ... how can achieve this

5 Answers   TCS,




Work flow failed when it is set to Bulk mode but it was successful when set to normal mode y??(All the connections are fine and exactly correct)?

11 Answers   Wipro,

hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

0 Answers   IBM,

Explain about HLD and LLD ?

16 Answers   Accenture,

If a table contains 100 records we have to fetch 50-100 records from source to target?how

7 Answers   CSC,

What is InformaticaPowerCenter?

0 Answers   Informatica,

What is DR strategy for Informatica project?

0 Answers  

what is sql override?what is the use of it?

4 Answers   Sonata,

For more Informatica Interview Questions Click Here
Categories