251. it is possible to run parallel jobs in server jobs?

252. what are the enhancements made in datastage 7.5 compare with 7.0

253. If I add a new environment variable in Windows, how can I access it in DataStage?

254. what is OCI?

255. Is it possible to move the data from oracle ware house to SAP Warehouse using with DATASTAGE Tool.

256. How can we create Containers?

257. what is data set? and what is file set?

258. How can I extract data from DB2 (on IBM iSeries) to the data warehouse via Datastage as the ETL tool. I mean do I first need to use ODBC to create connectivity and use an adapter for the extraction and transformation of data? Thanks so much if anybody could provide an answer.

259. it is possible to call one job in another job in server jobs?

260. how can we pass parameters to job by using file.

261. How can we implement Lookup in DataStage Server jobs?

262. what user varibale activity when it used how it used !where it is used with real example

263. Did you Parameterize the job or hard-coded the values in the jobs?
Always parameterized the job. Either the values are coming from Job Properties or from a ‘Parameter Manager’ – a third part tool. There is no way you will hard–code some parameters in your jobs. The o

264. what is hashing algorithm and explain breafly how it works?

265. what happends out put of hash file is connected to transformer ..what error it throughs

266. what is merge ?and how to use merge? merge is nothing but a filter conditions that have been used for filter condition

267. What will you in a situation where somebody wants to send you a file and use that file as an input What will you in a situation where somebody wants to send you a file and use that file as an input or reference and then run job.

268. What is the NLS equivalent to NLS oracle code American_America.US7ASCII on Datastage NLS?

269. Why do you use SQL LOADER or OCI STAGE?

270. What about System variables?

271. what are the differences between the data stage 7.0 and 7.5in server jobs?

272. How the hash file is doing lookup in serverjobs?How is it comparing the key values?

273. how to handle the rejected rows in datastage?

274. how is datastage 4.0 functionally different from the enterprise edition now?? what are the exact changes?

275. What is Hash file stage and what is it used for?
Used for Look-ups. It is like a reference table. It is also used in-place of ODBC, OCI tables for better performance.


276. What is the utility you use to schedule the jobs on a UNIX server other than using Ascential Director?
Use crontab utility along with d***ecute() function along with proper parameters passed.

277. How can I connect my DB2 database on AS400 to DataStage? Do I need to use ODBC 1st to open the database connectivity and then use an adapter for just connecting between the two? Thanks alot of any replies.

278. what is the OCI? and how to use the ETL Tools?
OCI means orabulk data which used client having bulk data its retrive time is much more ie., your used to orabulk data the divided and retrived Asked by: ramanamv

279. what is difference between serverjobs & paraller jobs

280. What is the difference between Datastage and Datastage TX?

281. Hi!Can any one tell me how to extract data from more than 1 hetrogenious Sources.mean, example 1 sequenal file, Sybase , Oracle in a singale Job.

282. How can we improve the performance of DataStage jobs?

283. How good are you with your PL/SQL?
On the scale of 1-10 say 8.5-9

284. What are OConv () and Iconv () functions and where are they used?
IConv() - Converts a string to an internal storage formatOConv() - Converts an expression to an output format.

285. If data is partitioned in your job on key 1 and then you aggregate on key 2, what issues could arise?

286. How can I specify a filter command for processing data while defining sequential file output data?

287. There are three different types of user-created stages available for PX. What are they? Which would you use? What are the disadvantage for using each type?

288. What is DS Manager used for - did u use it?

289. What are Sequencers?
Sequencers are job control programs that execute other jobs with preset Job parameters.

290. Functionality of Link Partitioner and Link Collector?

291. Containers : Usage and Types?
Container is a collection of stages used for the purpose of Reusability. There are 2 types of Containers. a) Local Container: Job Specific b) Shared Container: Used in any job within a project.

292. Does Enterprise Edition only add the parallel processing for better performance?Are any stages/transformations available in the enterprise edition only?

293. what are validations you perform after creating jobs in designer.what r the different type of errors u faced during loading and how u solve them

294. how can you do incremental load in datastage?

295. how we use NLS function in Datastage? what are advantages of NLS function? where we can use that one? explain briefly?

296. Dimension Modelling types along with their significance
Data Modelling is Broadly classified into 2 types. a) E-R Diagrams (Entity - Relatioships). b) Dimensional Modelling.

297. Did you work in UNIX environment?
Yes. One of the most important requirements.

298. What other ETL's you have worked with?
Informatica and also DataJunction if it is present in your Resume.

299. What is APT_CONFIG in datastage

300. Does the BibhudataStage Oracle plug-in better than OCI plug-in coming from DataStage? What is theBibhudataStage extra functions?