Answer Posted / guest
The DTM uses reader, transformation, and writer threads to
extract, transform, and load data
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Explain the pipeline partition with real time example?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
How to update a particular record in target with out running whole workflow?
In warehouses how many schemas are there?
What are the different versions of informatica?
While migrating the data from one environment to another environment how would you manage the connections?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
Whats the difference between informatica powercenter server, repositoryserver and repository?
Where are the source flat files kept before running the session?
Which transformation should we use to normalise the COBOL and relational sources?
What is the command used to run a batch?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Enlist the various types of transformations.
What is dimensional table?
How many ways are there to do 'remove duplicate records in informatica'?
