Why do flat file load is faster if you compare that with
table load ?
Please answer me.
Advance Thanks,
Manojkumar
- 11 Answers
- 15785 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / joe
In case of dbases- time is consumed to make the dbase
connection for reading/writing data to the table.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are junk dimensions?
What is sorter transformation?
While migrating the data from one environment to another environment how would you manage the connections?
how to load rows into fact table in data warehouse
How do you load alternate records into different tables through mapping flow?
What are connected or unconnected transformations?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What is workflow monitor?
What is a pre-defined event and user-defined event?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Whats there in global repository
How many transformations can be used in mapplets.
in reporting we add some new objects,how we get the count of the newly added objects to the report
