What is a diff between joiner and lookup transformation
Answer Posted / kittu
hi every one
i read all the answers i agree with you but one more thing is there in joiner. once u specify d joiner it will extract all the data from source and check the based on condition then it returns values.
in look up it wont take any values but it refers based on condition.It means look up check the values present r not.
here main thing is memory if cache size is increase it decrease the informatica performance.same thing will happen in joiner trans so mostly we r not using joiner but some times based on source data we use.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Implementation methodology
tell me the rules and responsblites in our project(my project is development)
Why union transformation is an active transformation?
generate date / time dimension in informatica
What is the session task and command task?
How to improve the performance of a session using sorter transformation?
can u any challenge your project?
Explain your project of banking domian.
What do you understand by a term domain?
4 yrs etl devloper roles and responsibilities?any body give solutions
COM components can be used in Informatica
Write the prerequisite tasks to achieve the session partition?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What is transformation?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks