|
INTERVIEW QUESTIONS
DATA WAREHOUSING
DATASTAGE
DETAILS
Question: How we use NLS function in Datastage? what are advantages of NLS function? where we can use that one? explain briefly?
Answer: By using NLS function we can do the following
- Process the data in a wide range of languages
- Use Local formats for dates, times and money
- Sort the data according to the local rules
If NLS is installed, various extra features appear in the product.
For Server jobs, NLS is implemented in DataStage Server engine
For Parallel jobs, NLS is implemented using the ICU library.
|
|
|
Category |
DataStage Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.3) By 7864 users |
Added on |
7/26/2011 |
Views |
72950 |
Rate it! |
|
|
Question:
How we use NLS function in Datastage? what are advantages of NLS function? where we can use that one? explain briefly?
Answer:
By using NLS function we can do the following
- Process the data in a wide range of languages
- Use Local formats for dates, times and money
- Sort the data according to the local rules
If NLS is installed, various extra features appear in the product.
For Server jobs, NLS is implemented in DataStage Server engine
For Parallel jobs, NLS is implemented using the ICU library. Source: CoolInterview.com
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|
|
Related Questions |
View Answer |
|
What is merge ?and how to use merge?
|
View Answer
|
|
What is difference between serverjobs & paraller jobs
|
View Answer
|
|
How can ETL excel file to Datamart?
|
View Answer
|
|
what is the mean of Try to have the constraints in the 'Selection' criteria of the jobs itself. This will eliminate the unnecessary records even getting in before joins are made?
|
View Answer
|
|
What is the meaning of the following..
1)If an input file has an excessive number of rows and can be split-up then use standard
2)logic to run jobs in parallel
3)Tuning should occur on a job-by-job basis. Use the power of DBMS.
|
View Answer
|
|
How to implement routines in data stage,have any one has any material for data stage pl send to me
|
View Answer
|
|
How can u implement slowly changed dimensions in datastage? explain?
2) can u join flat file and database in datastage?how?
|
View Answer
|
|
How can you implement Complex Jobs in datastage
|
View Answer
|
|
Does Enterprise Edition only add the parallel processing for better performance?
Are any stages/transformations available in the enterprise edition only?
|
View Answer
|
|
How can you do incremental load in datastage?
|
View Answer
|
|
If your running 4 ways parallel and you have 10 stages on the canvas, how many processes does datastage create?
|
View Answer
|
|
If data is partitioned in your job on key 1 and then you aggregate on key 2, what issues could arise?
|
View Answer
|
|
What is the difference between Datastage and Datastage TX?
|
View Answer
|
|
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
|
View Answer
|
|
How can I specify a filter command for processing data while defining sequential file output data?
|
View Answer
|
|
Can we use shared container as lookup in datastage server jobs?
|
View Answer
|
|
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.
|
View Answer
|
|
What is the exact difference betwwen Join,Merge and Lookup Stage??
|
View Answer
|
|
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?
|
View Answer
|
|
What user varibale activity when it used how it used !where it is used with real example
|
View Answer
|