what is the difference between static and dynamic
Answer Posted / rajendra
Static:It is the tempoarary data to store
we cant update during the loading time
Dynamic:we update the during the data loading
| Is This Answer Correct ? | 24 Yes | 4 No |
Post New Answer View All Answers
Can u generate reports in Informatica?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
Why union transformation is an active transformation?
What is the status code in stored procedure transformation?
What do you mean by blocking transformation?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What are the features of complex mapping?
What is different between the data warehouse and data mart?
What is the function of look up transformation?
What is a connected transformation?
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
What are the different transaction levels available in transaction control transformation?
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?
How can we use mapping variables in informatica? Where do we use them?
What is a sorter transformation?