HOE DO U IMPLIMENT SCHEDULING IN INFORMATICA?
Answers were Sorted based on User's Feedback
Answer / bsgsr
using the informatica schedular tool or third party tools
like control m, maestro, tivoli etc. if wrong sorry
Is This Answer Correct ? | 26 Yes | 3 No |
Answer / rajan
Informatica has own Sheduling components .Since Informatica
widely used as Data integration and Data warehousing Entity
and there are lots of depedencies on other jobs ,reason
informat application is scheduled by external sheduluing
device such as
1) Control M
2) Crontab
3) maestro
Basic Functionlity behind scheduling is PMCMD cmd thro
shell scripts they trigger informatica jobs via pmcmd
command.
Is This Answer Correct ? | 11 Yes | 3 No |
Answer / abhas kumar jain
There are following ways:
-- Use the scheduler in WF manager.
-- Use cron scheduler in Unix.
-- Use pmcmd scheduleworkflow command.
-- Use third party enterprise schedulers like Ctrl-M,
Redwood or Tidal etc.
If any query....gimme a call on 9833547028.
Is This Answer Correct ? | 6 Yes | 1 No |
Answer / 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 |
Answer / nisith
I think no one know abt Informatica DAC-Its a scheduling
tool of informatica like control M
Is This Answer Correct ? | 6 Yes | 3 No |
Answer / purna
scheduling is an administrative tool to perform to run the
session at a specific time and date. if wrong pls inform it
Is This Answer Correct ? | 2 Yes | 5 No |
which transformation uses cache?
how can we convert a column into row in informatica? Eg: INPUT- a x Output Like: a b c b y x y z c z
List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys
What are multi-group transformations?
Why is meant by direct and indirect loading options in sessions?
daily how much amount of data send to production?
Mention some types of transformation?
without dynamic lookup how to insert new rows and update existing rows?
how can we load starting with 11th record of a table from source to target
I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG I need to get max date and its corresponding flag for both the date columns. Ex:- 1A,10/3/2015,AC,10/3/2015,XY 1A,10/4/2015,AB,10/2/2015,XZ Output needed 1A,10/4/2015,10/3/2015,XY I have 100 million + in the table so avoid self-join...
What are session parameters ? How do you set them?
why we are using surogate key in real time give me explanation