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 / sudheer
As u r using source as flat file so u can go for partitioning preferably Single-Thread or Multi-Thread partitioning.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain how to import oracle sequence into informatica?
What are the uses of etl tools?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
can you please explain me pre session and post session options?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What is meant by query override?
Explain sql transformation in script mode examples in informatica
What is joiner change?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
How is union transformation utilized?
generate date / time dimension in informatica