Interested to Buy Any Domain ? << Click Here >> for more details...
How to fasten loading of 100 million distinct records in
informatica?
(Initially they are loaded into target without using any
transformation, taking 2 hours)
- 3 Answers
- 10932 Views
- Atriax, I also Faced
- E-Mail Answers
Answer Posted / dev
Have index on the sources and make sure indexes are dropped in target(any ways these are distinct records) before load and opt for bulk loading. Once load is done you can create thee indexes again and maybe analyze the table also.
| Is This Answer Correct ? | 14 Yes | 0 No |
Post New Answer View All Answers
server hot-ws270 is connect to Repository B. What does it mean?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What are the popular informatica products?
What is depict expression change?
What if the source is a flat-file?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
Define enterprise data warehousing?
What is powercenter on grid?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
Explain load alternative records / rows into multiple targets - informatica
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
write a query to retrieve the latest records from the table sorted by version(scd)
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?
complex mapping ur project u r invlve can u explain and give real time example give me ?
What is expression transformation?
