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 |
. Design a mapping, first two phone calls received by a customer must be represented as "Home" , "Office" and the next calls must be concatinated and represented as "Other".Look at the below tables :: Source Definition Customer Phone_Number A 9848403211 A 9812675432 A 9112356788 A 9876503276 B 9567890765 B 9876098567 AND THE TARGET IS Customer Home Office Other A 9848403211 9812675432 9112356788,9876503276 B 9567890765 9876098567 Null
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What is a joiner transformation?
Differentiate between a database and data warehouse?
How informatica process data means how informatica works?
Explain scd type 3 through mapping.
can you please explain me pre session and post session options?
how many types transformations supported by sortedinput?
1)What is Data Masking in informatica? 2)How to restrict junk characters while loading data into target. 3) what happen if i won't pass sorted input in a transformation.
i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me
Please let me know how to make encryption and decryption with example?
tell me some dimension tables names in banking domain informatica project(dont tell like depends on project, tell me names of dimension and fact table names in your project)?