Can you explain engine tier in information server?
No Answer is Posted For this Question
Be the First to Post Answer
Converting Vertical PIVOTing without using PIVOT stage in DataStage. Ex: DEPT_NO EMPNAME 10 Subhash 10 Suresh 10 sravs Output: DEPT_NO EMP1 EMP2 EMP3 10 subhash suresh sravs 2) How to implement Horizontal PIVOTing without using PIVOT stage.
How do you import and export data into datastage?
How do u convert the columns to rows in datastage?
Star Schema vs. Snow Flake Schema. What is the best model for DW? Give example for both the models performance wise?
Which commands are used to import and export the datastage jobs?
Have you have ever worked in unix environment and why it is useful in datastage?
what is parameterset?
INPUT file 'A' contains: 1 2 3 4 5 6 7 8 9 10 input file 'B' contains: 6 7 8 9 10 11 12 13 14 15 Output file 'X' contains: 1 2 3 4 5 Output file 'Y' contains: 6 7 8 9 10 Output file 'Z' contains: 11 12 13 14 15 How can we implement this in a single ds job?
What are the environmental settings for data stage,while working on parellel jobs?
What is a ds designer?
A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?pls pls
What are the different types of lookups in datastage?