Interested to Buy Any Domain ? << Click Here >> for more details...
If a session fails after loading of 10,000 records in to the
target. How can you load the records from 10001 th record
when u run the session next time?
- 4 Answers
- 18670 Views
- I also Faced
- E-Mail Answers
Answer Posted / ambarish
In the workflow manager you have option go to workflow----
>EDIT---check this box suspend on error
if the work fails after loading 10000 records with error
you can correct the error and restart the workflow which
will load strating from 10001.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Mention few power centre client applications with their basic purpose?
Explain what transformation and how many are there in informatica?
What is a code page?
What are the popular informatica products?
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
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What all are steps in up gradation of Informatica server?
How to join three sources using joiner? Explain though mapping flow.
What are the settings that you use to configure the joiner transformation?
What do you mean by blocking transformation?
what are factless facts? And in which scenario will you use such kinds of fact tables.
How we can create indexes after completing the loan process?
How to call shell scripts from informatica?
What are the various types of transformation?
What is enterprise data warehousing?
