Interested to Buy Any Domain ? << Click Here >> for more details...
Do joiner transformation use cache? If so describe?
- 2 Answers
- 6953 Views
- Patni, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Enlist the tasks for which source qualifier transformation is used.
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
What are session parameters ? How do you set them?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
Informatica settings are available in which file?
How to load the data from a flat file into the target where the source flat file name changes daily?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What is update strategy transform?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
Briefly define reusable transformation?
What is lookup transformation?
What are roles and groups and benefits of using them?
