Interested to Buy Any Domain ? << Click Here >> for more details...
in what type of scenario bulk loading and normal loading we use?
- 2 Answers
- 6875 Views
- Cognizant, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
We use bulk loading in such senarious where there is bulk amount of data is to be loaded into target.
ie we when we want yo load large amount of data fast into the target we use bulk loading.
when u dont want to do the session recovery and u r target should not contain any primary keys
we use normal loading in such senarious when u want to do session recovery.It looks about the constrain based
loding
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / amol palekar
main difference between normal and bulk load is, in normal load Informatica repository service create logs and in bulk load log is not being created. That is the reason bulk load loads the data fast and if anything goes wrong the data can not be recovered. But in normal load since the log is created the lost data can be recovered.
| Is This Answer Correct ? | 0 Yes | 0 No |
Define Update Override?
What is a test load?
Why update strategy and union transformations are active? Explain with examples.
How can you display only hidden files in UNIX
Source (Flatfile) - Target (1-1 mapping). How to load first or last 20 record to target?
What are the different ways to implement parallel processing in informatica?
. Design a mapping, first two phone calls received by a customer must be represented as "Home" , "Office" and the next calls must be concatinated and represented as "Other".Look at the below tables :: Source Definition Customer Phone_Number A 9848403211 A 9812675432 A 9112356788 A 9876503276 B 9567890765 B 9876098567 AND THE TARGET IS Customer Home Office Other A 9848403211 9812675432 9112356788,9876503276 B 9567890765 9876098567 Null
Which means the first record should come as last record and last record should come as first record and load into the target file?
How to recover sessions in concurrent batches?
How can a transformation be made reusable?
what is system requirement(SR) & business requirement(BR)?
Does Facttable Normalized or Denormalized?
Teradata 
