Hi Friends,
I want lo truncate my records from target before loading
current month data,but i dont have permission to truncate
with truncate option
if u know any other way please give your valuable input for
this.
Thanks
Abhishek
Answer Posted / sunil
Abhishek Bhai,
Possible Solution:-
1. While creating connection, use such a generic id, which
have all the permission on DB objects. This way you
definitely can play with your Target object.
2. If no such credential available then, Delete and commit
process can be implemented in pre-sql.. but process will
become very slow (depends on volume of data).
Cheers !
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the format of informatica objects in a repository?
What are the types of schemas we have in data warehouse.
In informatics server which files are created during the session rums?
can u give example for factless fact table
What is the meaning of up gradation of repository?
What is domain in terms of informatica?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
Is stop and abort are same in informatica?
what is INFORMATICA TESTING process
Implementation methodology
Explain what are the different versions of informatica?
Why update strategy and union transformations are active? Explain with examples.
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
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.