Interested to Buy Any Domain ? << Click Here >> for more details...
i have flat file and using unix how can i generate sequence
number into targer?
- 1 Answers
- 10077 Views
- Cap Gemini, I also Faced
- E-Mail Answers
you can Use cat -n flatFile>Target to Generate line numbers.
| Is This Answer Correct ? | 6 Yes | 0 No |
Main Function of the Staging area in DWH ?
input Name Salay Sam 10 Sam 30 Sam 20 Ram 40 Ram 50 Output should be Name Salary Count Sam 10 3 Ram 40 2 get min salary and count of name . OutPut 2 Name Seq Sam 1 Sam 2 Sam 3 Ram 1 Ram 2
Describe the main features of datastage?
What are the different database update actions available?
How can u execute the sql query through unix? What is the Primary key for Dimension table? what is the primary key for Fact table?
What are the main differences you have observed between 7.x and 8.x version of datastage?
when will you go for dataset and fileset?
1.which index is follows the dimensions tables?why? 2.what is the use of trigger in job sequence? 3.what is the mean of optimization? 4.what is the job control?when we use it? what is difference bet batch and sequencer? 6.seq--->seq,seq--->copy--->seq which one is best and efficient?
What is container and then types?
Explain the importance of surrogate key in data warehousing?
Emp login_timestamp Logout_timestamp A,2019-02-01 02:24:15,2019-02-01 04:59:42 B,2019-03-29 14:43:30,2019-03-29 20:22:00 ABC,2019-03-29 12:43:00,2019-03-29 23:22:59 In the above calculate the duration of hours spent in office for each emp in datastage.
Different ways a project can be moved to production ?...example ….export-import and Version control.
Teradata 
