HI Experts,
What is BULK mode and NORMAL mode, Which one gives better
performance. How? Please Explain with an example...! It
will help's me a lot.
Thanks In advance.
Answer Posted / guravareddy
When u chose target load type Normal mode the integration service creates database log and is used in session
recovery.
Where as in bulk mode the integration service by pass load the data into target, but its not
possible to create a session recover.
But in Bulk mode its faster in peformance.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explian the Process of deployment groups in informatica
expain about the tune parameters?
draw informatica architecture 8.6 ?
Can we change Dynamic to Static or Persistent cache? If so what happens?
What are the components of Informatica? And what is the purpose of each?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
lookup transformation with screenshots
What is aggregate cache in aggregator transformation?
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 to create or import flat file definition in to the warehouse designer?
How you can differentiate between connected lookup and unconnected lookup?
Please let me know how to make encryption and decryption with example?
Enlist the various types of transformations.
What are the basic requirements to join two sources in a source qualifier transformation using default join?