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 / srinu
My understanding from ur ques--Target havining 5 rows
(Related to Sorce source rows),
Can u Explain (5 m rows Briefly)
srinu.srinuvas@gmail.com
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How to update or delete the rows in a target, which do not have key fields?
In which transformation you cannot drag ports into it?
How would you join a node to the already existing domain?
What is the difference between STOP and ABORT options in Workflow Monitor?
How we can create indexes after completing the loan process?
What is a grid in Informatica?
Separate from an archive server and a powerhouse?
Which transformation should we use to normalise the COBOL and relational sources?
What is workflow? What are the components of the workflow manager?
What is source qualifier transformation in informatica?
What is update strategy transform?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
How can we remove the duplicates from flat file source?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.