Interested to Buy Any Domain ? << Click Here >> for more details...
Hi I have two sources like A, B. My source A contain 10000
million records from that i need 20 attributes. My source B
has also same 10000 million records from that i need only 1
attribute. By using Joiner i have to load into target? Is
there any issue regarding this? if issue is there how to
tune this mapping in best way?
- 2 Answers
- 6740 Views
- Zensar, I also Faced
- E-Mail Answers
Answer Posted / anu
IF 2 SOURCES ARE RELATIONAL USE SQ T/R
WRITE MANUVAL QUERY
first connect requrired 16+1 attributes to furter t/r or target
select required columns and in where condition write matched condition
if there is no common column go to joiner create sequence in both sources then compare sequence in join vondition
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to delete duplicate row using informatica?
what is the Default Source Option For Update Strategy Transformation?
Which is the t/r that builts only single cache memory?
Is it possible to create multiple domains on a single Informatica server?
Write the prerequisite tasks to achieve the session partition?
How to do the error handling of if ur source is flatfiles?
What are the new features of informatica 9.x in developer level?
What is a transaction control transformation?
What are the advantages of informatica?
Implementation methodology
Performance tuning( what you did in performance tuning)
What is session task and command task?
What is deployment group?
without table how to come first record only in oracle?
How can informatica be used for an organization?
