What are two types of processes that informatica runs the
session?
- 2 Answers
- 18231 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / swetha
Load manager Process: Starts the session, creates the DTM
process, and sends post-session email when the session
completes.
The DTM process. Creates threads to initialize the session,
read, write, and transform data, and handle pre- and
post-session operations.
| Is This Answer Correct ? | 16 Yes | 2 No |
Answer / rekha
LOAD MANAGER : LOAD MANAGER IS THE FIRST COMPONENT NEEDS TO
BE INITIALIZES WHEN THE SESSION IS SUBMITTED TO THE SERVER
LOAD MANAGER MANAGES THE LOAD ON THE INFORMATICA SERVER BY
MAINTAINING A QUEUE OF SESSIONS AND RELEASES THE SESSIONS
BASED ON FIRST COME FIRST SERVE
ONCE THE LOAD MANAGER RELEASES THE SESSION IT
INTIALIZES THE DTM PROCESS
DTM FOLLOWS THE INSTRUCTIONS CODED IN THE SESSION
MAPPING ,FOR EACH SESSION DTM CRAETES READER ,WRITER AND
SHARED MEMORY
| Is This Answer Correct ? | 4 Yes | 0 No |
can we create index and drop index in exsisting table while using infomatica
how can u tune u r informatica mapppings
How do we do the Fact Load What is the size of your Data warehouse? What is your Daily feed size and weekly feed size
in oracle write query yourname+1 from dual
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?
How might you approve all mappings in the archive all the while?
Can you generate sequence numbers without using the sequence generator transformation?
suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping using aggregator & router? how
I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
whether Sequence generater T/r uses Caches? then what type of Cache it is
HOW DO YOU PARFORM INCREMENTAL LAOD ?
Teradata 
