how may sources can be used in a mapping at a time?(limit)
Answers were Sorted based on User's Feedback
Answer / sathish
we can use any number of source becouse we can get the data from any ny\umber of sources
| Is This Answer Correct ? | 27 Yes | 0 No |
Answer / sbvp
i agree with mr.satish we will use n number source in
single mapping
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / amedela chandra sekhar
WE CAN USE ANY NO OF SOURCES IN A MAPPING AT A TIME.THERE IS NO LIMIT.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
Answer / naveen
yes Chandra Sekhar you are right, we can use any number of source in a mapping, there is limitation.
| Is This Answer Correct ? | 1 Yes | 0 No |
what is work of PUSH DOWN option
I have the source like col1 col2 a l b p a m a n b q x y How to get the target data like below col1 col2 a l,m,n b p,q x y
How to jion 2 tables, without using any condition?
What is data movement mode in Informatica and difference between them?
i have 2 mapings for this 2 mapings i want use only one lookupt/r how?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..
What are the differences between source qualifier and joiner transformation?
performance tuning of Informatica
Can we write to_date(three arguments) ? Will it work ? Advance thanks
Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can you use them in the mapping?
How to delete duplicate record in Informatica?