how may sources can be used in a mapping at a time?(limit)
Answer Posted / akash
When we are using multiple sources and bringing them in a
single data flow, we need joiners.
No. of Joiners = No. of sources - 1
So this will also depend upon how many joiners can we use
in our mapping.
As per my understanding we can use upto 8 joiners in a
mapping so that it remains stable due to cache memory
constraint.
Please let me know if this is correct.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is an aggregator transformation?
Describe data concatenation?
How to load last n records of file into target table - informatica
What is resilience time?
How can you differentiate between powercenter and power map?
How to convert multiple rows to single row (multiple columns) in informatica
Explain Dataware house architecture .how data flow from intial to end?
What is fact table? Explain the different kinds of facts.
what is size of u r database?
differences between service based and product based?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What are the different clients of powercenter?
How do you load alternate records into different tables through mapping flow?
How we can create indexes after completing the load process?
What is flashback table ? Advance thanks