explain the scenario for bulk loading and the normal
loading option in Informatica Work flow manager ???
- 8 Answers
- 34843 Views
- CTS, TCS, I also Faced
- E-Mail Answers
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
What is dimensional table?
how tokens will generate?
what are factless facts? And in which scenario will you use such kinds of fact tables.
what is degenerated dimension?
What are the advantages of informatica?
CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks
What is Data Caches size?
Explain the scenario which compels informatica server to reject files?
Is there any way to read the ms excel datas directly into informatica?
How to delete duplicate row using informatica?
What is fact table? Explain the different kinds of facts.
Explain in detail about scd type 1 through mapping.
How to do unit testing in informatica? How to load data in informatica ?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What is the session task and command task?
