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 filelist concept in informatica
How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...
Which files are created during the session rums by informatics server?
How can u work with remote database in informatica?did you work directly by using remote connections?
What is the sequence generator transformation in informatica?
TELL ME ABOUT WORK FLOW SCHEDULING?
how can we update without using update transformation. wt is push down operation in informatica. which lookup gives more tuning performance. if so why.
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is operational data source (ODS)?
Can you access a repository created in previous version of Informatica?
. Design a mapping, first two phone calls received by a customer must be represented as "Home" , "Office" and the next calls must be concatinated and represented as "Other".Look at the below tables :: Source Definition Customer Phone_Number A 9848403211 A 9812675432 A 9112356788 A 9876503276 B 9567890765 B 9876098567 AND THE TARGET IS Customer Home Office Other A 9848403211 9812675432 9112356788,9876503276 B 9567890765 9876098567 Null
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?