What is a diff between joiner and lookup transformation
Answer Posted / kalpana
joiner doesnt support nonequi joins where as lookup support
nonequijoin
Is This Answer Correct ? | 72 Yes | 12 No |
Post New Answer View All Answers
What are the different lookup cache(s)?
Mention a few design and development best practices for informatica?
What is an Integration service in Informatica?
How might you approve all mappings in the archive all the while?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
in reporting we add some new objects,how we get the count of the newly added objects to the report
Explain in detail scd type 2 through mapping.
What is target load order?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
How can one identify whether mapping is correct or not without connecting session?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
While migrating the data from one environment to another environment how would you manage the connections?
Explain the types of lookup transformation?
What do you understand by term role-playing dimension?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?