when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?
Answer Posted / sandeep desai
when session scheduled then load type is bulk mode at that time integration service bypass the database log file..it not create it and you cannot rollback the data
but in normal mode integration service create database log file and u can rollback the data
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Can we create a Integration service without a Repository service and vice versa?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What are the different types of repositories created using informatica?
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
Explain pmcmd command usage in informatica
expain about the tune parameters?
How to improve the performance of a session using sorter transformation?
How do you set a varible in incremental aggregation
Explain why we use partitioning the session in informatica?
What all are steps in up gradation of Informatica server?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
In warehouses how many schemas are there?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
how we can load rejected record's at run time?(not through bad files)
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.