Why do flat file load is faster if you compare that with
table load ?
Please answer me.
Advance Thanks,
Manojkumar
- 11 Answers
- 16398 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / nidhi
To write data in table informatica server generate the insert statement for each row where as for flat file write the data row wise in file.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
How to convert multiple rows to single row (multiple columns) in informatica
Explain how to import oracle sequence into informatica?
difference between informatica 8.1.1 and 8.6
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What is an expression transformation in informatica?
How do you load only null records into target? Explain through mapping flow.
what is the -ve test case in your project.
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What are different types of transformations available in informatica?
What is meant by incremental aggregation?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Define filter transformation?
What does refresh system mean, and what are its distinctive choice?
expain about the tune parameters?
