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 |
while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?
I have source data like this col1 col2 col3 5 3 8 6 2 9 7 1 10 and i want to get target as col1 col2 col3 5 1 8 6 2 9 7 3 10 which transformation i have to use and how?
how to load only the first and last record of a flat file into the target?
what is $$$$?
Source --------- eno , ename, sal 001,ank,1000 002,behe,2000 003,raj,2500 Target ------- header :DDMMYYYY24MMSS timestamp body: 001,ank,1000 002,behe,2000 003,raj,2500 footer: count(eno),sum(sal) how to implement the same in a FF tgt?
From where you extract the data, how you did it into informatica? explain....
1 Answers Accenture, Unisoft Infotech,
How to load the data from people soft hrm to people soft erm using informatica?
What do you understand by a term domain?
What is difference between Informatica 6.2 Workflow and Informatica Workflow 7.1
suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping?how
what is metadata?
what are the enhancements made to Informatica 7.1.1 version when compared to 6.2.2 version?