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
- 6688 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 the cumulative sum and moving sum?
Can u generate reports in Informatica?
What is enterprise data warehousing?
How to open an older version of an object in the workspace?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
Define filter transformation?
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?
Can we create a Integration service without a Repository service and vice versa?
Enterprise data warehouse your projects phase by phase explain?
What is a node in Informatica?
Mention some types of transformation?
Name the different lookup cache(s)?
Which version configuration tool used in ur project?
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
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
