Interested to Buy Any Domain ? << Click Here >> for more details...
How i can Schdule the Informatica job in "Unix Corn
Schduling tool" ?
- 2 Answers
- 11716 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ram
Crontab
The crontab (cron derives from chronos, Greek for time; tab
stands for table) command, found in Unix and Unix-like
operating systems, is used to schedule commands to be
executed periodically. To see what crontabs are currently
running on your system, you can open a terminal and run:
sudo crontab -l
To edit the list of cronjobs you can run:
sudo crontab -e
This wil open a the default editor (could be vi or pico, if
you want you can change the default editor) to let us
manipulate the crontab. If you save and exit the editor,
all your cronjobs are saved into crontab. Cronjobs are
written in the following format:
* * * * * /bin/execute/this/script.sh
Scheduling explained
As you can see there are 5 stars. The stars represent
different date parts in the following order:
1. minute (from 0 to 59)
2. hour (from 0 to 23)
3. day of month (from 1 to 31)
4. month (from 1 to 12)
5. day of week (from 0 to 6) (0=Sunday)
Execute every minute
If you leave the star, or asterisk, it means every. Maybe
that's a bit unclear. Let's use the the previous example
again:
* * * * * /bin/execute/this/script.sh
They are all still asterisks! So this means
execute /bin/execute/this/script.sh:
1. every minute
2. of every hour
3. of every day of the month
4. of every month
5. and every day in the week.
In short: This script is being executed every minute.
Without exception.
Execute every Friday 1AM
So if we want to schedule the script to run at 1AM every
Friday, we would need the following cronjob:
0 1 * * 5 /bin/execute/this/script.sh
Get it? The script is now being executed when the system
clock hits:
1. minute: 0
2. of hour: 1
3. of day of month: * (every day of month)
4. of month: * (every month)
5. and weekday: 5 (=Friday)
Execute on weekdays 1AM
So if we want to schedule the script to run at 1AM every
Friday, we would need the following cronjob:
0 1 * * 1-5 /bin/execute/this/script.sh
Get it? The script is now being executed when the system
clock hits:
1. minute: 0
2. of hour: 1
3. of day of month: * (every day of month)
4. of month: * (every month)
5. and weekday: 1-5 (=Monday til Friday)
Execute 10 past after every hour on the 1st of every month
Here's another one, just for practicing
10 * 1 * * /bin/execute/this/script.sh
Fair enough, it takes some getting used to, but it offers
great flexibility.
| Is This Answer Correct ? | 13 Yes | 1 No |
Answer / sudhir kumar
we can do this by using crontab file in unix,
For this we need to sheduled the Powercentre job.
or
we can use "at" commmand in unix to schedule the job.
| Is This Answer Correct ? | 6 Yes | 2 No |
Explain pushdown optimization and types in informatica
My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?
what is the difference between Informatica 7.1 and Abinitio?
What is the sequence generator transformation in informatica?
Write the program through which the records can be updated?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
Diffrence between static and dynamic cache
What is main use of mapplet?
I am getting five sources in a day and i donot know when i get them. i need to load data into the target and run the session. but here i can't keep the session in running or can't stop the session. plz help me
Can we write to_date(three arguments) ? Will it work ? Advance thanks
Is it possible to revert a global repository to local one and why?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Teradata 
