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
- 6876 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
What is a router transformation?
What is decode in informatica?
What is the scenario which compels informatica server to reject files?
What is the difference between informatics 7x and 8x and what is latest version?
What is InformaticaPowerCenter?
How can you validate all mappings in the repository simultaneously?
can we override a native sql query within informatica? Where do we do it?
Explain the informatica workflow?
What is a sorter transformation?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
How many numbers of sessions can one group in batches?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
How to differentiate between the active and passive transformations?
Under which circumstances, informatica server creates reject files?
Define mapping and session?
