HOE DO U IMPLIMENT SCHEDULING IN INFORMATICA?
Answer Posted / usha
1:-informataica tool its has scheduler
2:-by using UNIX also we can schedule wf (cron tab command)
3:-by using thired party tools also we can schedule wf
control_m,redwood cronical tool
third party tool is easy because we schedule wf accoring to
the customer requrement for example i want to schedule only
for leapyear.
4:- by usin shell scripts also we can schedule
Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
How to improve the performance of a session using sorter transformation?
How to extract the informatica rejected data?
How to configure mapping in informatica?
Explain about cumulative Sum or moving sum?
what is INFORMATICA TESTING process
CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks
How to elaborate tracing level?
Explain target update override in informatica
How do you take back up of repository?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What is confirmed fact in dataware housing?
Quickly characterize reusable change?
What is different between the data warehouse and data mart?
wf dont have integration severances how you can run?
What is a joiner transformation?