what is the difference between normal & bulk loading? and
which one is recommended ? why?
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 |
I have a Flat file with more no. of Records also including duplicate values. But i need distinct values to one target and remaining records to another target in Informatica way
what is Forward,Reverse and Re_engineering?
Two default user groups created in the repository are____and_____.
What are the different ways to deploy the code in informatica?
1 Answers IBM, Saama Tech, Wipro,
Do we need an etl tool?
What is etl process?
What is full load & incremental or refresh load?
A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?
In the SEQ generator which property has to be set to generate seq No. when the input data is more than the max limit.
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
What is Data Vault???
What is staging area referring to?