explain the scenario for bulk loading and the normal
loading option in Informatica Work flow manager ???
Answer Posted / addy
Hi
I would like to mention- apart from logging differences
there is a crucial diffrence - if we are running the session
in bulk target load mode we cant recover a session from the
same point when we run it for the next time.
whereas if we are running the session in normal target load
mode we can recover the session if the output being loaded
to the target is deterministic in nature - this is relay a
helpful feature with the applications handling RealTime data.
-addy
| Is This Answer Correct ? | 31 Yes | 4 No |
Post New Answer View All Answers
Explain lookup transformation source types in informatica
what is the size of your data warehousing?
How many numbers of sessions can one group in batches?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
have u done any performance tuning? how u ll do?
How do you load alternate records into different tables through mapping flow?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
what are factless facts? And in which scenario will you use such kinds of fact tables.
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What are the features of complex mapping?
What are the tasks that can be performed using sq?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?