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
- 6647 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
Parameter and variable differences
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
What differs when we choose the sorted input for aggregator transformation?
In how many ways we can create ports?
What is informatica metadata and where is it stored?
Different qualification between a related rotate toward the sky and isolates look upward?
What is a router transformation?
How do you load first and last records into target table?
Describe an informatica powercenter?
How do you use reject loader.
differences between service based and product based?
what is INFORMATICA TESTING process
How to create or import flat file definition in to the warehouse designer?
what is the complex transformation you used in informatica
waht type of interface is used for testing the data in informatica
