in what type of scenario bulk loading and normal loading we use?
Answer Posted / 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 |
Post New Answer View All Answers
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
If informatica has its scheduler why using third party scheduler?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
How will the document be delivered to me?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
server hot-ws270 is connect to Repository B. What does it mean?
What is a standalone command task?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
how to load dimension table and fact table. plz tell me the steps.
What is confirmed fact in dataware housing?
How to generate sequence numbers?
How to partition the Session?
What does “tail –f” command do and what is its use as an Informatica admin.