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
- 8796 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
What is the different lookup cache(s)?
What is domain and gateway node?
What is a rank transform?
What is meant by incremental aggregation?
Why do we need informatica?
Explain what are the different types of transformation available in informatica.
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Explain informatica architecture - version 8 / 9
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.
what is INFORMATICA TESTING process
What's the layout of parameter file (what does a parameter file contain?)?
Explain pushdown optimization and types in informatica
How to generate or load values in to the target table based on a column value using informatica etl tool.
What is meant by a domain?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
