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
- 6860 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
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
What does command task mean?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
Describe the impact of several join conditions and join order in a joiner transformation?
What do you mean by channel change?
What is domain in terms of informatica?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
how to load rows into fact table in data warehouse
What is the Process to creating lookup transformation in informatica
What is rank transformation in informatica
Enlist the tasks for which source qualifier transformation is used.
What is complex mapping?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
How do you remove duplicate records in informatica? And how many ways are there to do it?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
