What are the different threads in DTM process?
Answers were Sorted based on User's Feedback
Answer / rekha
DTM CREATES MASTER THREAD ,IT CONATINS THE FALLOWING
READER THRAD
WRITER THREAD
MAPPING THREAD
TRANSFORMATION THREAD
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / guest
The DTM uses reader, transformation, and writer threads to
extract, transform, and load data
| Is This Answer Correct ? | 2 Yes | 1 No |
What is InformaticaPowerCenter?
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
what is mapping parameter?
I've a denormalized table EMP(empno,ename,phone,addr1,addr2,fax,email). Now I want to insert the record into target in the format that, there will be 2 target rows for 1 source record. In target the row needs to be inserted as: ROW1: empno,ename,addr1,phone ROW2: empno,ename,addr2,fax,email And I'm not allowed to normalize transformation. How to achieve?
What's the layout of parameter file (what does a parameter file contain?)?
On lookup on any table we can get only a)any value or b)last value but if i need both duplicate values How can i achieve?
how to load only the first and last record of a flat file into the target?
what is the predefined port in dynamic lookup
Explain how many types of dimensions are available in informatica?
What is the difference between informatica 7.0 and 8.0?
Quickly characterize reusable change?
what are surrogate keys?