What are the tasks that Loadmanger process will do?
- 1 Answers
- 4891 Views
- I also Faced
- E-Mail Answers
Answer Posted / swetha
Manages the session and batch scheduling: When you start the
informatica server the load maneger launches and queries the
repository for a list of sessions configured to run on the
informatica server. When u configure the session the
loadmanager maintains list of list of sessions and session
start times. When u sart a session loadmanger fetches the
session information from the repository to perform the
validations and verifications prior to starting DTM process.
Locking and reading the session: When the informatica server
starts a session lodamaager locks the session from the
repository. Locking prevents U starting the session again
and again.
Reading the parameter file: If the session uses a parameter
files,loadmanager reads the parameter file and verifies that
the session level parematers are declared in the file
Verifies permission and privelleges: When the sesson starts
load manger checks whether or not the user have privelleges
to run the session.
Creating log files: Loadmanger creates logfile contains the
status of session.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Enlist some properties of sessions.
What are the advantages of using informatica as an etl tool over teradata?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
4 yrs etl devloper roles and responsibilities?any body give solutions
Is it possible to define a single node as a Gateway node as well as worker node?
According to his methodology what all you need before you build a datawarehouse
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
How can you define user defied event?
Scheduling properties,whats the default (sequential)
Describe data concatenation?
In informatica workflow manager, how many repositories can be created?
rank() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid order by case when opt2.dm_market_flg in ('Y', 'U') then 1 else 2 end, lkp.contact_rank) as rank1, case opt2.contact_type when 'Buyer' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, ship_to_flg desc , last_order_dt desc) when 'Decision Maker' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc , last_quote_dt desc , mailability_score desc , source_ranking desc) when 'Influencer' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, mailability_score desc, source_ranking desc) when 'Payer' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, mailability_score desc, source_ranking desc) --elu 05/28/2013 else row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, mailability_score desc, source_ranking desc) end rank2 row_number() over (partition by opt3.dim_plat_site_id, opt3.dim_site_opt_sid order by rank1,rank2) as "rank", case when "rank"<= opt3.maximum_value then 'Y' else 'N' end as include_flg
What do you understand by term role-playing dimension?
What is aggregate cache in aggregator transformation?
