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
- 40674 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Is it possible to use a client with different version than that of its Informatica server?
What are the data movement modes in informatica?
How to create a non-reusable instance of reusable transformations?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
1. When u r checking out what ll happens for version no? a. Increase b. decrease c.reset to 0 d. reset to 1 e. no change 2. Salary of all employees needed to add with the commision. What transfrmation to be used? a. SQ and Expression b. SQ c. Update Strategy d. Expression 3. Which of the task is used to run a session based on success of the other session? a. Decision b. Event wait c. Email d. Command e. None 4. Types of sources in Informatica? a. Homogenous n Heterogenous b. None c. Cobol n XML d. Flat files e. Flat files and Homogenous n Heterogenous 5. Servers are available in informatica? a. Informatica Server and Workflow server b. Informatica Server and Informatica Repository Server c. Informatica Server d. Workflow server e. Informatica Repository Server 6. While using Pmcmd in cmd line mode, each command must include the connection info of which of the following? a. workflow manager b. Power Center server c. Workflow monitor d. Repository manager e. Designer 7. Workflow montior displays workflows that have run a. once b. twice c. never d.four times e. thrice 8. Mode for handling sessions n workflows? a. server mode b. Wait mode c. Command line mode d. User mode e. Interactive mode 9. Connection details configured in? a. Mapping designer b. Workflow manager c. Workflow monitor d. Repository manager e. Worklet designer Thanks in Advance
which one is better performance wise joiner or look up
Which is the t/r that builts only single cache memory?
When do you use sql override in a lookup transformation?
Make a note of the quantity vaults made in informatica?
Difference between Data and Index Caches?
Write the unconnected lookup syntax?
How can we handle two sessions in informatica?
What is data caches/ index caches?
waht type of interface is used for testing the data in informatica
How to generate sequence numbers without using the sequence generator transformation?
