what is the difference between lookupoveride and joiner?
Answer Posted / nikhil
Using lookupoverride u can join two relational tables but
not flat files . Joniner T is used to join two heterogenous
sources like relational tables from two different databases
or flat file sources.
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What are the differences between joiner transformation and source qualifier transformation?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
How does a rank transform differ from aggregator transform functions max and min?
What are the mapping parameters and mapping variables?
What are the uses of etl tools?
How do you load only null records into target?
Can we override a native sql query within informatica?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
draw informatica architecture 8.6 ?
How do you remove duplicate records in informatica? And how many ways are there to do it?
In warehouses how many schemas are there?
How do you convert single row from source into three rows into target?
What are the popular informatica products?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??