how can we create tables in datastage?
Answer / hanug
The DB tables will be created in two ways
1. By right clicking on on the navigator on any of the
folder, you can choose NEW -> Table definition
2. We can also create new table using Database stages.
| Is This Answer Correct ? | 2 Yes | 8 No |
2.how u run your rotines in unix? what is job sequencer? if i have 4 jobs i would like to run 2 jobs in server(using job jobsequencer)and remaining 2 in parallel?how can i run?
Differentiate between datastage and datastage tx?
What are routines in datastage?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
What are the different plug-ins stages used in your projects?
how do you pass parameters in a script?
diff between changecapture & diffrence stage which situvation we can use the diffrence stage ?
I am having two tables called MASTER and DETAIL. I want to insert records to both tables. But one condition is that whenever the insert for MASTER table is success then only the records will inserted into the DETAIL table, otherwise abort the job. How can u design this job?
Where do the datastage jobs get stored?
What are system variables and sequencers in datastage
Define data aggregation?
can explain wt is the pool for file.