how may sources can be used in a mapping at a time?(limit)
- 6 Answers
- 10029 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 |
How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks
From where you extract the data, how you did it into informatica? explain....
1 Answers Accenture, Unisoft Infotech,
My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000
which transformation uses cache?
what are the deliverables?in your project?
How to load the source table into flat file target(with columns) in informatica?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What happens if the info. Server doesn't find the session parameter in the parameter file?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Explain scd type 3 through mapping.
Explain the types of transformations?
My i/p is like below 1,2,3,4,5,6,7,8,9,10....100 I want that to be populated in two o/p as below o/p-1: 10,20,30,40,50,60,70,90... o/p-2: 11,21,31,41,51,61,71,81,91.... How to do it in ingotmatica...
Teradata 
