Answer / ramya

By using some third party schedule tools we can achieve
this..
like Autosys and Control -M

Answer / bietl

we can do this in different ways.

1. we can right the userdefine shell script.
2. we can do with Job sequences by selecting Start - loop
and End -loop activties.
3. we can do with datastage director by scheduling.

I hope this will help ..

Answer / dileep

Can we try like this?

Schedule the job for every 12hours

Answer / subramanyam

you can even use DS Director to schedule th jobs...

Answer / vnrrahul

Create multiple sequencers for same job and schedule the sequencers.

Answer / kpk

you can even use DS Director to schedule th jobs...

Answer / hari

Hi this is Hari

I thing using Invocation Id we can run the job more than one
time in oneday.

In detailed

we have an option in Job properties---->Allow multiple
instance (enable this one and)

At the time running it will ask invocation id give the id
how many times u want run in particular day...

I think this will help you....

i have a table col1 10 20 30 40 10 20 50 my requirement is how to retrive only duplicates like 10 10 20 20 like this how it's possible in SQL?

11 Answers   Cap Gemini,

What a datastage macro?

0 Answers  

IS IT POSSIBLE TO USE DATASET AS A SOURCE FILE?

3 Answers   Infosys,

i have the source from Uk,north america how can i pass the data two tables based on the locations

2 Answers  

AGGREGATOR default datatype

0 Answers   CTS,

5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10

2 Answers  

Hi Friends, I have a input data like, class_id Marks 101 50 101 60 101 40 102 90 102 35 And i want my output data like class_id Marks Rank 101 50 2 101 60 1 101 40 3 102 90 1 102 35 2 how to do this in datastage?

8 Answers   Cognizant, HCL, TIAA CREF,

1.i have 5 jobs(1-5),i connect with each other,i want run from 3-5 only how? 2.how to schedual the job in datastage7.5 2? what is the deff bet grip and fgrep command? how do you cleanse the data in your project

1 Answers   Accenture,

how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

0 Answers   HCL,

i have source data like empno,enmae 11 ,aa 12 ,bb i want output like empno,ename 11 ,aa 12 ,bb 11 ,aa 12 ,bb

7 Answers   TCS,

Drop duplicate records ... SOURCE LIKE .......... ID flag1 flag2 100 N Y 100 N N 100 Y N 101 Y Y 101 N Y 102 Y N 103 N N 104 Y Y 105 N N 106 N Y 102 N Y 105 Y Y in above file if any id having both the flags as "N" then that corresponding id records should be dropped, in above case o/p should be as ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y Steps to do : 1) Identified the id’s that got duplicated (both the flag values having vales “N”) 2) Look up with these id’s to existing id’s to drop .

2 Answers  

i have data like sam ram sam raj ram I want two targets trgt1 ram sam trgt2 raj how can i do this in datastage?

4 Answers   IBM,