What is limitations of truncate and load option
- 1 Answers
- 8833 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer / abhinaw prakash
You cannot rollback the data in case of failed session.
In this scenario you need to write delete query(delete from
tablename) and uncheck the Truncate target table option.
| Is This Answer Correct ? | 13 Yes | 0 No |
what is incremental loading ?
12 Answers CTS, IBM, Oracle, TCS,
Explain in detail scd type 2 through mapping.
Does an informatica transformation support only aggregate expressions?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
normalizer transformation
there is a comma separated flat file as source and there is a column in that one field is having space like "rama krishna" like that what happens when this is used as source
What is parameter file?
What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort
how to declare array in plsql?
What is the difference between informatica 7.0 and 8.0?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
Teradata 
