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 / prakash
USE NOCACHE,IT WILL GIVE BETTER PERFORMANCE RATHER THAN
JOINER
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What are the components of workflow manager?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
How does a sorter cache works?
Define joiner transformation?
What is mapping debugger?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
Can you generate sequence numbers without using the sequence generator transformation?
Tell me about Propagate functions in informatica
what is the size ur source like(file system or database)? how many record daily come u r banking project?
How to delete duplicate row using informatica?
Clarify the utilization of aggregator cache record?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Parameter and variable differences
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance