Interested to Buy Any Domain ? << Click Here >> for more details...
how to get the unique records on multiple columns by using
sequential file stage only
- 3 Answers
- 9960 Views
- I also Faced
- E-Mail Answers
Answer Posted / chandu
in sequential file there is one option is there i.e
filter.in this filter we use unix commands like what ever we
want.in this question we use uniq command in filter.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What is the difference between passive stage and active stage?
What are the types of jobs we have in datastage?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
whom do you report?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
Define Merge?
Differentiate between validated and Compiled in the Datastage?
Explain usage analysis in datastage?
On which interface you will be working as a developer?
What are the various kinds of the hash file?
What is active and passive stage?
Differentiate between datastage and datastage tx?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
What are some prerequisites for datastage?
Can you highlight the main features of ibm infosphere information server?
