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
- 6229 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 |
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What are Dimensions and various types of Dimensions?
How to update a particular record in target with out running whole workflow?
What is Datadriven?
Explain the different kinds of facts.
Source (Flatfile) - Target (1-1 mapping). How to load first or last 20 record to target?
What all join we can perform in LOOKUP transformation?
what is data modelling? what are types of modelling?In which suituation will use each one?
empno sal 1 8000 2 9000 3 8000 4 1000 how to get highest sal wise rankings in rank t/r.
In which circumstances that informatica server creates Reject files?
in a table it has 200 rows the query is select 150 from tablename.whats the output
what is informatica metadata?
Teradata 
