Interested to Buy Any Domain ? << Click Here >> for more details...
i have two sources two flatfiles same structure
one flatfile contain 100 million recs
another flatfile contain 10 million recs
i have to connect single target(performance oriented answer)
what are the steps we have to do this scenario
- 4 Answers
- 8406 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / srikanth
Hi,
Both teja and Babu Answers are correct..
But here we need to consider Performance wise which one is
better.
here we have only two flat files one is having 100 million
records and second one having 10 million records.
union transformation can supports for flat files also and it
is acting as union all(don't worry about this).
first drag the 100 million records source and then drag the
10 million records source on mapping designer.
connect these two sources to union transformation.
union transformation can merge the Data By COLUMN by COLUMN.
so it is trying to merge only 10 million records with
existing 100 million records
Then we can tune the performance here.
if we have lot of flat files(same structure) then we have to
go for file indirect.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Can u generate reports in Informatica?
Define mapplet?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What are the issues you have faced in your project? How did you overcome those issues?
which one is better performance wise joiner or look up
Mention some types of transformation?
What is different between the data warehouse and data mart?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
Explain lookup transformation source types in informatica
What are the popular informatica products?
How can we update a record in the target table without using update strategy?
What is deployment group?
Write the unconnected lookup syntax?
What is main use of mapplet?
What are the components of workflow manager?
