Interested to Buy Any Domain ? << Click Here >> for more details...
Do joiner transformation use cache? If so describe?
- 2 Answers
- 6956 Views
- Patni, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mike
Yes joiner transformation has cahches. It joins the data
based on master detail joining condition. It first reads
the master source and stores it in the joiner cache and it
reads the detail source and joins with the data in the
joiner cache based on the master detail joining condition.
correct me if i was wrong
| Is This Answer Correct ? | 17 Yes | 0 No |
Answer / krish
Caching Master Rows
When the Integration Service processes a Joiner
transformation, it reads rows from both sources concurrently
and builds the index and data cache based on the master
rows. The Integration Service then performs the join based
on the detail source data and the cache data.
ur right buddy
| Is This Answer Correct ? | 2 Yes | 0 No |
what are the different types of transformation available in informatica and what are the mostly used ?
How can we improve session performance in aggregator transformation?
Diffrence between static and dynamic cache
How do you set a varible in incremental aggregation
what is bridge tables in informatica
what is the difference between onsite & client site?
What is a difference between complete, stop and abort?
how to load the data in fact table.. using look up transformation how to view the second record. usally look up shows matching record for only one value. if i have same value its not displaying. ex: problem i faced. i have total, student no and name in table student i used aggregation transformation to display max(total). i have two same max values in total. when i look up the student name and no for this max(total), its showing only one name and no, its leaving the second one. how to rectify it. plz tel me step by step or clearly.
I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.
can we override a native sql query within informatica? How do we do it?
where does the default group roew in a router is stored what is the default size of memory in router
Hi frndz, "while i am going to run the infotmatica power designer,he ask the id and password ",then i enterd the id and passwd , at that time i got the error as " failed to connect repository " ?
Teradata 
