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
- 6642 Views
- Zensar, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / muni
take B table as master....A table as a detail.... so we can reduce serch process in joiner
than based on which column we are going to do join create a index on it
i hope it will give gud per'mance
if i i am worng plz create it
| Is This Answer Correct ? | 1 Yes | 0 No |
HI Experts, What is BULK mode and NORMAL mode, Which one gives better performance. How? Please Explain with an example...! It will help's me a lot. Thanks In advance.
Whats there in global repository
What are the Differences between static cache and dynamic cache?
I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.
surrogate keys usage in Oracle and Informatica?
5 Answers ITC Infotech, Oracle,
what is datamart
what is the architecture of any Data warehousing project?
a soure table has 100 records how to load into 3 target tables in a cumulative order source target1 target2 target3 --------- ------------------------------------- 1-100 1 2 3 4 5 6 - - - 98 99 100
How do we come to know the Source data/file is ready/Updated in the source location, when the session is scheduled for @12:00AM and ready to run its job ? or Can we schedule the session, when the source is updated in source location without any time constraint?
How does the aggregator transformation handle null values?
I want to get an license to produce excel format output using informatica tool. Anyone help me in this issue. Thanks in advance, Vishnuvardhan
what are factless facts? And in which scenario will you use such kinds of fact tables.
Teradata 
