Interested to Buy Any Domain ? << Click Here >> for more details...
in what type of scenario bulk loading and normal loading we use?
- 2 Answers
- 6749 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 a command that used to run a batch?
my source is a comma delimited flatfile as eno, ename, sal 111,sri,ram,kumar,1000 and my target should be eno ename sal 111 sri ram kumar 1000 i.e; we need to eliminate the commas in between the data of a comma delimited file.
What is the difference between a connected look up and unconnected lookup?
Separate from a database, an information bazaar, and an information stockroom?
follwing scenario two table using find maximum salary? table a table b 101 xxx 1000 106 6500 103 yyy 5000 108 800 104 din 6000 109 7000 105 dsh 200 110 3000
disable caching in a lookup transformation?
In dimension and fact table? which one holds big data?
How can you use an Oracle sequences in Informatica? You have an Informatica sequence generator transformation also. Which one is better to use?
what are the challenge face in u r project?explain me
My source table look like ID Name Location Salary 0000001 ran tpty 1000 0000002 ram DELHI 2000 hju-hji raj hyd 1000 my target table should be ID Name Location Salary 1 ran tpty 1000 2 ram DELHI 2000 hju-hji raj hyd 1000
Explain scd type 3 through mapping.
How to Display top 2 salaries for each department WITHOUT using Rank Transformation And WITHOUT using SQL queries in source qualifier.
Teradata 
