Interested to Buy Any Domain ? << Click Here >> for more details...
Hai..,in datastage how to explain project in
interview?please explain any domain please.
- 1 Answers
- 13534 Views
- Wipro, I also Faced
- E-Mail Answers
Answer / ram y
first tell about
project name
client
team size
duration of project
r&r details
| Is This Answer Correct ? | 7 Yes | 2 No |
Lookup constraints
1. How many People are part of your Team? 2. Explain how you create jobs or flow of project? 3. Join Stage vs Lookup vs Merge Stage 4. Summation scenario based question - How you find sum of salary for a specific employee (Explain stages and flow of job)? 5. Explain Remove duplicates stage ? Can you do sort in this stage? 6. SQL Questions - Joins - Types, Difference between Join and Union 7. Unix Questions - How you run the Job, How you list all jobs in project 8. Explain Environmental Variables? 9. SQL Scenario - If you have 3 Identical record in a Table, Ex: 1, Ram, Xyz; 1, Ram, Xyz; 1, Ram, Xyz; Delete only 2 of the records and keep only 1 using the Delete query. How you will you do this?
What is the process of killing a job in datastage?
What are data elements?
how to capture rejected data by using join stage not for lookup stage. please let me know
Give an idea of system variables.
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
how can we create rank using datastage?what is the meaning of rank?
What is job control?
Why fact table is in normal form?
How can you write parallel routines in datastage PX?
Teradata 
