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.

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.

Any one can tell me how to explain puss-down optimization ? explain me with example plz?

1 Answers  

---

Explain sessions. Explain how batches are used to combine executions?

0 Answers  

---

Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its possible to Create 3parameters at a time? If Possible which one will fire FIRST?

6 Answers   Accenture, HCL,

---

How many joins in Informatica

5 Answers   CSC,

---

What is a grid in Informatica?

0 Answers  

---

---

generate Unique sequence numbers for each partition in session with Unconnected Lookup ? Hi All, Please help me to resolve the below issue while Applying partitioning concept to my Session. This is a very simple mapping with Source, Lookup , router, and target. I need to Lookup on the target and compare with the source data, if any piece of data is new then Insert, and If any thing change in the existed data then Update. while Inserting the new records to the target table I'm generating sequence numbers with Unconnected lookup, by calling the maximum PK ID from the target table. The above flow is working fine from last one year. Now I wish to apply the Partitioning concept to the above floe(session) At source I used 4 pass through partitions.(For Each partition different filter conditions to pull the data from source) at Target I used 4 passthrough Partitions. it is working fine for some data, but for some rows for Insert Operation , it is throwing Unique key errors, because while Inserting the data it is generating the same sequence key twice. In detail : 1st row is coming from 1st partition and generated the sequence number 1 for that row. 2nd row is coming from 1st partition and generated the sequence number 2 for that row 3rd row is coming from the 2nd partition generated the sequence number 2 again for that row. (it must generate 3 for this row) the issue is becuase of generating the same sequence numbers twice for different partitions. Can any one Please help me to resolve this issue. While Applying partitions how can I generate a Unique Sequence numbers from Unconnected lookup for Each partitioned data. Regrads, N Kiran.

2 Answers   Tech Mahindra,

---

how can you load data into target table without leading zeor's

4 Answers   Deloitte,

---

What is intricate mapping?

0 Answers  

---

What are the Differences between connected and unconnected lookup?

6 Answers   TCS,

---

where actually the usage of push down optimization happens...

2 Answers  

---

What is fact table? Explain the different kinds of facts.

0 Answers  

---

While migrating the data from one environment to another environment how would you manage the connections?

0 Answers  

---