Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 21 Answers
- 39309 Views
- Deloitte, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
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 |
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 |
How many number of sessions can one group in batches?
If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?
3. Suppose Seq Gen is supplying a increamental value to a column of a table, suppose, table's column value reaches to maximum value, then what will happen, will the session fail? If it is the situation, then what should be done so that we can stop this kind of situation in advance?
how the informatica server sorts the strings values in rank transformations?
what happens when a batch fails?
In session log thier should not be a single error how will u do
Where we use dynamic lookup and where we use it?do we generate surrogate keys using dynamic lookup?can we use it for scd type 2 mapping and why?
Why update strategy and union transformations are active?
When you connect to repository for the first time it asks you for user name & password of repository and database both. But subsequent times it asks only repository password. Why?
What is use of batch file in informatica? How many types of batch file in informatica?
explan ur project architecture?
explain about informatica server architecture?
Teradata 
