What is limitations of truncate and load option
- 1 Answers
- 8546 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 |
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
PLS REAL TIMERS IAM WAITING FOR FAVOROBLE REPLY..REGARDING ETL TESTING INFORMATION...ETL TESTER NEEDS ETL DEVOLPMENT KNOWLEDGE OR NOT..?. IF HE NEED DEVLPMNT KNOW WHAT HE LEANR FIRST... AS A DEVOLOPER U KNOW THE ETL TESTING PROCESS.. PLS EXPLAIN IN DETAIL THANK U
hi, as al you know, we can set the option in session level as all rows treat as like insert,update etc., And also we have update strategy for flaging records as insert,update etc.. then when we will go for above options and what is the difference.. explain..
difference between informatica 8.1.1 and 8.6
What is the difference b/w natural key and surrogate key
suppose we will take flatfile target and load type is bulkload the session fails why please give me the answer
What is hash partition?
Update strategy transformation is an active transformation.How it changes the number of records that pass through it? Please explain....
How do we do the Fact Load What is the size of your Data warehouse? What is your Daily feed size and weekly feed size
what is the logic will you implement to load data into a fact table from n dimension tables?
How we will implement Pushdown Optimization and Types in Informatica with better examples
write a query row to column follwing source? quarter sales q1 5000 q1 9000 q1 7000 q1 6000 q2 5000 q2 4000 q2 3000 q2 1000 q3 4000 q3 3000 q3 1000 q3 2000 q4 5000 q4 400 i want the output? q1 q2 q3 q4 sales
3 Answers Cognizant, Flextronics,
Teradata 
