Interested to Buy Any Domain ? << Click Here >> for more details...
What is limitations of truncate and load option
- 1 Answers
- 9837 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 |
tell me 7.x and 8.x diferrencess(but not transformations)
What is the need of an ETL tool?
what is upstream and downstream transformation?
What are the ETL tools available in DWH?
i have one source 52 million records i want target only 7 records ?how wil you do what logic to implement?
What is constraint based loading exatly? And how to do this? I think it is when we have primary key-foreign key relation ship. Is it correct? please answer me. Advance Thanks.
Mention some types of transformation?
get me output as if input is like 1 x o/p-->1 x,y,z 1 y 2 a,b 1 z 3 c 2 a 2 b 3 c
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
How to view and Generate Metadata Reports?
Dependecy Errors in Informatica ? Do u got any dependency problems while running session? Can any one Explain Clearly.
What are the types of lookup?
Teradata 
