What is limitations of truncate and load option
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 |
Can we use the mapping parameters or variables created in one mapping into another mapping?
who to split dimentions into sub dimention
How to load last n records of file into target table - informatica
(Integ) Start workflow: ERROR: User [practice] does not have sufficient privilege for this operation. how to solve this pls suggest me? THANKS in advance
Which transformation should we use to normalise the COBOL and relational sources?
can u apply SCD2 on flat file tgt? if yes wat is the procedure?
Can informatica load heterogeneous targets from heterogeneous sources?
Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its possible to Create 3parameters at a time? If Possible which one will fire FIRST?
How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?
Explain informatica architecture - version 8 / 9
What are the new features of informatica 9.x developer?
How union transformation is used?