Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between normal & bulk loading? and
which one is recommended ? why?
- 2 Answers
- 6766 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
normalloding:
this is the optin which we to set in the session under
mapping tab.this will represents the loading of data into
target.this is slower when compared to bulk load.this can
load the data even if u have constraints built on u r
target.this will create the session logs
bulloading
it is the faster loading method.we can' load if u have
constraint defined.this will not create sesion logs
generally normal loading is preffered
| Is This Answer Correct ? | 7 Yes | 2 No |
Answer / prasanna
Session log is always created in any mode you load. The
loading method is no way realted to creation of a session
log.
Normal mode: Will check for constraints while loading. Its
a process which happens record by record.
Bulk mode: This will not check for any constraints on DB.
So, generally when you don;t have any indexes or
constraints defined on your target table, you can use Bulk
mode which is faster.
In Informatica 8.6.1 , if you define bulk mode also.. if
your task need to perform Normal mode operation,
informatica will chabge it to Normal mode automatically run
time.
| Is This Answer Correct ? | 3 Yes | 0 No |
what is granularity in Data ware House?
IN Informatica, I have 10 records in my source system. I need to load 2 records to target for each run. how to perform.please let me know. I know by using Mapping variable we can perform but how to load please any one explain.
my name is amar i want display 1st line A 2nd line M 3rd line A 4th line R in database & informatica
what types of repositories we can create in informatica? in real time in which type of repository we will work on?
Eliminating of duplicate records without using dynamic lookups
What is tracing level? How many types of transformations supported by sorted input?
What is staging area referring to?
Identifying the bottlenecks in various components of Informatica and resolving them.
What is data modeling and data mining?
how do u identify the changed records in operational data?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
what are the concerns of OLTP and DSS systems?
Teradata 
