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 |
What are the mapping paramaters and mapping variables?
Explain in detail scd type 2 through mapping.
What are the measure objects?
i hav a scenario like this i want load data from source to target as follows frist it counts the num of deptno and display with that with count and how many times it reapts along with all the records in source
Explain the types of lookup transformation?
how many new transformations are introduced in 8.1 which are not available in 7.1? any new transformation in 8.6?
1,If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?
4 Answers CompuSoft, EDS, TCS,
If session fails after loading 10000 records in the target,how can we load 10001 th record when we run the session in the nexttime?
how to find the 5th highest salary form each department using 1.SQL Query 2. Informatica power center designer?
What is the internal processes of integration server in Informatica? How data will be extract and load to the target?
star and snowflake schema?
can we override a native sql query within informatica? Where do we do it?