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
- 40106 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Design time, run time. If you don't create parameter what will happen
How to differentiate between the active and passive transformations?
What is a passive transformation?
How to generate sequence numbers?
Can we create a node as a gateway node and the same node can be assigned to a grid?
What are the types of caches in lookup? Explain them.
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
Is it possible to revert a global repository to local one and why?
What are the types of schemas we have in data warehouse.
explain abt ur project architecture?
Partition, what happens if the specified key range is shorter and longer
As union transformation gives UNION ALL output, how you will get the UNION output?
Can we change Dynamic to Static or Persistent cache? If so what happens?
what is the hint? how to use it to reduce the query processing in program?
