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
- 8565 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
Design time, run time. If you don't create parameter what will happen
What are the different types of transformation available in informatica.
What are active and passive transformations?
server hot-ws270 is connect to Repository B. What does it mean?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What can we do to improve the performance of informatica aggregator transformation?
Explain about Informatica server process that how it works relates to mapping variables?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What happens when a session fails and you click on recover?
What do think which one is the better joiner or look up?
Explain the shared cache and re-cache?
Write the prerequisite tasks to achieve the session partition?
What is informatica?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
