Interested to Buy Any Domain ? << Click Here >> for more details...
major difference between normal loading and bulk loading?
- 6 Answers
- 12388 Views
- I also Faced
- E-Mail Answers
Answer Posted / james
The major difference is while going with normal load,we can
have session recovery whereas in Bulk loading we can't.
Some of the other differences are as follows:
Normal Bulk
1.Enters session log before 1.Doesn't enter the session
loading into target there by log and loads directly in
increasing the loading time. target there by decreasing
the loading time.
2.Less performance. 2.High performance.
3.Indexing possible. 3.No concept of indexing.
4For small amount of data. 4.For huge amount of data.
Please let me know if you have any further differences.
Thanks.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What is parallel processing in informatica?
To import the flat file definition into the designer where should the flat file be placed?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What is lookup transformation?
What are active and passive transformations?
Write the advantages of partitioning a session?
Explain the difference between a data warehouse and a data mart?
What is sq transformation?
Tell me about Propagate functions in informatica
How might one distinguish in the case of mapping is right or not without associating session?
Explain target update override in informatica
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
Write the different tools in the workflow manager?
Under which circumstances, informatica server creates reject files?
