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

Answer Posted / tejaetl

i answered this question both the flatfiles connet to union

connect to single target

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Describe data concatenation?

575


What is persistent lookup cache?

605


What is complex mapping?

641


What is confirmed fact in dataware housing?

5693


How many types of sessions are there in informatica.please explain them?

678






Define joiner transformation?

598


What is different between the data warehouse and data mart?

630


Tell me about Propagate functions in informatica

524


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 ?

1745


What is event and what are the tasks related to it?

617


difference between repository database and repository service?

626


Explain the mapping variable usage example in informatica

635


How does a sorter cache works?

573


How can repository reports be accessed without sql or other transformations?

730


complex mapping ur project u r invlve can u explain and give real time example give me ?

1845