Why do flat file load is faster if you compare that with
table load ?
Please answer me.
Advance Thanks,
Manojkumar
Answer Posted / suresh
Here the records has to pass through the database drivers and ODBC connections are required, which is a time taking process.
But where as records from flat files are copied in easier way
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
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 .
Could you explain what is enterprise data warehouse?
What is the reusable transformation?
What is a pre-defined event and user-defined event?
How to generate sequence numbers using expression transformation?
How can we remove the duplicates from flat file source?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
Under what condition selecting sorted input in aggregator may fail the session?
how we can load rejected record's at run time?(not through bad files)
Differentiate between Load Manager and DTM?
What is standalone command task?
Enlist few areas or real-time situations where informatica is required.
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use