Interested to Buy Any Domain ? << Click Here >> for more details...
in what type of scenario bulk loading and normal loading we use?
- 2 Answers
- 6742 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 |
What is the need of building a data warehouse?
on a day i load 10 rows in my target and on nextday i get 10 more rows add to my target but out of 5 are update row how ican send them to target?how i can insert and update the records
yesterday my session run ten min.today its run 30min, wt is the reason? if any issues how to solve that?
how can we load 365 flat file to a single fact table (target) as a history load in single mapping?
What is an Integration service in Informatica?
Which are the different editions of informatica powercenter that are available?
How can i set break points in debugging mode ? can explain steps please?
in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?
If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?
Tell me one complex query in oracle ?
how we load the data from source to staging area
Why touse stored procedure in ETL Application?
Teradata 
