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 meant by lookup transformation? Explain the types of lookup transformation?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
is it possible to index the data in cache of lkp transformation ?
lookup transformation with screenshots
How might you approve all mappings in the archive all the while?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What is a stored procedure transformation?
How to elaborate tracing level?
Explain the features of connected and unconnected lookup.
What are the different components of powercenter?
What are ETL Tools?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
Which is the t/r that builts only single cache memory?
How to do unit testing in informatica?
What are the new features of informatica 9.x developer?