Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between stop and abort
- 2 Answers
- 5653 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / aparna
stop command immediately kills the reading process and does
not have any time period
Abort command gives a time out period of 60sec to the
informatica server to finish the dtm process else it kills
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / abhinaw prakash
STOP:When we issue Stop command the integration service
stops reading data from the source though it keeps on
processing and committing the data to the target.
ABORT: When we issue Abort command the integration service
has a timeout period of 60 sec.If its not able to finish
processing and committing the data to the target it kills
the DTM session.
| Is This Answer Correct ? | 2 Yes | 0 No |
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What is difference between maplet and reusable transformation?
What is the Rankindex in Ranktransformation?
What is the main data object present inbetween source and target. I answered Mapping. Transformation etc.. But it is not the answer. So please give me an apt answer. Thanks in advance
When to use normalization transformation other than cobol source?
In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?
How we will implement Pushdown Optimization and Types in Informatica with better examples
What are the different types of code pages available in informatica & how to implement it in your project?
What is the actual work done in Development and in the production depts in building a datawarehouse. Which dept is more interesting and career oriented .
Define error Threshold?
What are variable ports and list two situations when they can be used?
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
Teradata 
