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 |
Explain Dataware house architecture .how data flow from intial to end?
What is the advantage of persistent cache? When it should be used.
write a query row to column follwing source? quarter sales q1 5000 q1 9000 q1 7000 q1 6000 q2 5000 q2 4000 q2 3000 q2 1000 q3 4000 q3 3000 q3 1000 q3 2000 q4 5000 q4 400 i want the output? q1 q2 q3 q4 sales
3 Answers Cognizant, Flextronics,
when i was running the seesion, after loading 100 records, session suddenly fails.Next time i want to load the remaing rows in target with out truncate target table.What should i use?
Explain why we use partitioning the session in informatica?
1)how to generate sequnce numbers in informatica without using sequnce genarator transformation. 2)i have number of records in my sourse, but iwant to display first and last record only. how it is possible in informatica. 3)i want to update the records without using updatestrategy transformation. 4)what is diffrance between ab-intio and datastage than compared to informatica. 5)what is the latest version of informatica in our field.
3. Suppose Seq Gen is supplying a increamental value to a column of a table, suppose, table's column value reaches to maximum value, then what will happen, will the session fail? If it is the situation, then what should be done so that we can stop this kind of situation in advance?
What is the difference between informatica 7.0 and 8.0?
Parameter and variable differences
explain abt union t/r?
can we send mail when ever it get success or faulure to other mailid?(Not company mail id)
in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com these records i need to send in target table as below format. vishnuraju,suresh,krishna