explain the scenario for bulk loading and the normal
loading option in Informatica Work flow manager ???
Answer Posted / sankar
NORMAL LOADING:THE INTEGRATION SERVUCE CREATE THE DATA BASE
LOG BEFORE LOADING DATA INTO THE THE TARGET DATA BASE.SO
--THE INTEGRATION SERVICE PERFORM ROLL BACK AND SESSION
RECOVERY.
BULK LOADING:THE INTEGRATION SERVICE IN WORK THE BULK
UTILITY WHEN BYPASS THE DATA BASE LOG
--THIS IS IMPROVES THE PERFORMANCE DATA LOADING
--THIS IS NOT PERFORM ROLLBACK
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What are some examples of informatica etl programs?
How do you remove duplicate records in informatica? And how many ways are there to do it?
What is union transformation?
What is the difference between informatica 7.0 and 8.0?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
Describe expression transformation?
Do you find any difficulty while working with flat files as source and target?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Briefly define a session task?
Explain the use of aggregator cache file?
Explain in detail about scd type 1 through mapping.
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What is meant by lookup transformation? Explain the types of lookup transformation?
How do you set a varible in incremental aggregation