1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

What are the different threads in DTM process?

Question Posted / swetha


What are the different threads in DTM process?..

Answer / swetha

Master thread: Creates and manages all other threads

Maping thread: One maping thread will be creates for each
session.Fectchs session and maping information.

Pre and post session threads: This will be created to
perform pre and post session operations.

Reader thread: One thread will be created for each partition
of a source.It reads data from source.

Writer thread: It will be created to load data to the target.

Transformation thread: It will be created to tranform data.

Is This Answer Correct ?    5 Yes 0 No

Post New Answer

More Informatica Interview Questions

What is blocking transformation?

0 Answers   Informatica,

which T/r we can use it mapping parmeter and mapping variable? and which one is reusable for any mapping mapping parmeter or mapping varibale?

3 Answers   Wipro,

Why do we use DSS database for OLAP tools?

2 Answers  

if i have records like these (source table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk 10001 gfhgdgh 10002 hjkdghkfh the target table should be like these by using expression tranformation. (Target table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk xx001 gfhgdgh xx002 hjkdghkfh (that means duplicated records should contain XX in there rowid)

5 Answers   iFlex,

What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

0 Answers  




Any one can tell me how to explain puss-down optimization ? explain me with example plz?

1 Answers  

If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?

9 Answers  

What r the type of indexes u generally used in informatica?

2 Answers   Keane India Ltd,

what are factless facts? And in which scenario will you use such kinds of fact tables.

0 Answers  

What is the different lookup cache(s)?

0 Answers  

what is song in infrmatica...?

0 Answers   CTS,

source table have 3 records? and it is sucessfully loaded into target. and 4more records is added in to source .that means 7 records now in source. we have to load the remaining 4 records into the same trgt table with maintian top 3 records. how ?can any one give me the data flow of this logic plz?

5 Answers   Wipro,

For more Informatica Interview Questions Click Here
Categories