Interested to Buy Any Domain ? << Click Here >> for more details...
in what type of scenario bulk loading and normal loading we use?
- 2 Answers
- 6765 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 |
can session assigned multiple mappings or not?
How can we create index after completion of load process?
What is workflow? What are the components of the workflow manager?
why we r using presql&postsql in source qualifier?
How many joins in Informatica
How will the document be delivered to me?
i have a session which creates a file every time when i runs the session, but it replaces the first file with second file,i want to append the second file follwed by first file when i runs the session,how to achieve this?
Can any one explain or sujjest some sites for scd mappings.Thank you
After draging the ports of three sources(sql server,oracle,informix) to a single source qualifier, can you map these three ports directly to target?
In which circumstances that informatica server creates Reject files?
What is Session and Batches?
can you use flat file for repository?why?
Teradata 
