Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between stop and abort
- 2 Answers
- 5521 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 |
what is fact and what types of fact tables is there
i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table: pls full details
8 Answers L&T, TCS, UnitedHealth Group, Wipro,
My source table look like ID Name Location Salary 0000001 ran tpty 1000 0000002 ram DELHI 2000 hju-hji raj hyd 1000 my target table should be ID Name Location Salary 1 ran tpty 1000 2 ram DELHI 2000 hju-hji raj hyd 1000
A mapping contains (1) Source Table S_Time ( Start_Year, End_Year ) (2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )
when we create source as oracle and target as flat file, how can i specify first row as column in flat file?
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?
What is enterprise data warehousing?
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
Where we use dynamic lookup and where we use it?do we generate surrogate keys using dynamic lookup?can we use it for scd type 2 mapping and why?
how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy
following table source name gender a1 male a2 female how to change 'male' to 'female' and 'female' to 'male'
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
Teradata 
