Interested to Buy Any Domain ? << Click Here >> for more details...
how may sources can be used in a mapping at a time?(limit)
- 6 Answers
- 9483 Views
- IBM, I also Faced
- E-Mail Answers
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 sql override?what is the use of it?
while creating the scd mappings. we will mention flag value. what exactly the use of defining the FLAG VALUE. Please explaine indetaile
what is diffrence b/w joner and union transfermation
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Explain the informatica workflow?
Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..
If one flat file contains n number of records., we have to load the records in target from 51 to 100.. how to use expressions in Informatica..?
in flatfile target how can u create header and footer plese give me the comands how will u write in session properties
How or for what purpose look up transformation would be useful in Sales or Banking Project? Please reply!
What are the differences between a connected lookup and unconnected lookup?
How to read data from flat file source if the data is in paragraph format?
What are mapplets? How is it different from a Reusable Transformation?
Teradata 
