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
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What is the status code in stored procedure transformation?
COM components can be used in Informatica
In informatica workflow manager, how many repositories can be created?
What is data caches/ index caches?
What is a filter transformation?
How do you update the records with or without using update strategy?
Explain the mapping variable usage example in informatica
What is data movement mode in Informatica and difference between them?
If informatica has its scheduler why using third party scheduler?
what is index?how it can work in informatica
What does cheating measurement mean?
How identifying bottlenecks in various components of informatica and resolving them?
Describe an informatica powercenter?
can we override a native sql query within informatica? Where do we do it? How do we do it?