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 the sql query overwrite in source qualifier in informatica
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
What all join we can perform in LOOKUP transformation?
What is pmcmd command?
define galaxy repository in informatica
According to his methodology what all you need before you build a datawarehouse
What is different between the data warehouse and data mart?
Difference between Target-based loading and constraint-based loading?
What is sq transformation?
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
How identifying bottlenecks in various components of informatica and resolving them?
What is exclusive and normal mode for repository services?
EXL informatica Questions