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
Answer Posted / sri
Hi Sudhakatr.lake !
Why Static
Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
What does role playing dimension mean?
What are the reusable transformations?
How to delete duplicate row using informatica?
Differentiate between source qualifier and filter transformation?
How to generate sequence numbers without using the sequence generator transformation?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Can we change Dynamic to Static or Persistent cache? If so what happens?
How are indexes created after completing the load process?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Sequence generator, when you move from develoment to production how will you reset
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
What does reusable transformation mean?
How can you increase the performance in joiner transformation?
What is the cumulative sum and moving sum?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?