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
- 8629 Views
- Polaris, I also Faced
- E-Mail Answers
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
What is union transformation in informatica?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
Can we create a node as a gateway node and the same node can be assigned to a grid?
What are the types of presistent cache in look up tr.
What is enterprise data warehousing?
What are the main features of Oracle 8i with context to datawarehouse?
What are the advantages of using informatica as an etl tool over teradata?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
How will the document be delivered to me?
Explain lookup transformation source types in informatica
What is Data Caches size?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
