Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 1 Answers
- 1429 Views
- I also Faced
- E-Mail Answers
Answer / mahesh
Explain how you create jobs or flow of project?
Meta Data Import - Stages with Transformation logics - Load into Staging Tables
Join Stage vs Lookup vs Merge Stage
Differences
Mentioned about Input and Output, Reject Links
Mentioned about Volumes of Data etc.,
Summation scenario based question - How you find sum of salary for a specific employee (Explain stages and flow of job)?
Import Meta data - Database Connector - Filter Stage - Aggregator stage (Sum) - To list Result into a file Ex. Dataset
Explain Remove duplicates stage ? Can you do sort in this stage?
Removes the Duplicate values based on the First retained or second retain
Remove duplicates does have only internal sort, As a Recommendation It is better if we send Remove duplicate stage sorted data.
6. SQL Questions - Joins - Types, Difference between Join and Union
Join Types
Full Outer
Left Outer
Right Outer
Inner Join
Union vs Full outer: Union is similar to the Funnel stage in DS. Union need to be done on tables which has similar meta data where as Full outer need a matching Column between 2 or more tables
7. Unix Questions - How you run the Job, How you list all jobs in project
dsjob -run projectname jobname
dsjob -ljobs projectname
8. Explain Environmental Variables?
Can be created from DS Administrator, from User defined variables. Which can be used across all the projects in Datastage
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?
- I didn't answer this. Please let me know if you have any thoughts. Which will help for future interviews. Thanks
| Is This Answer Correct ? | 0 Yes | 0 No |
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
what is the difference between == and eq in UNIX shell scripting?
i/p o/p1 o/p2 1 1 4 1 1 5 1 1 6 2 2 2 2 2 2 3 3 4 5 6 how to populates i/p rows into o/p1&o/p2 using datastage stages?and also the same scenario using sql?
How to Convert the columns into rows?
Explain connectivity between datastage with datasources?
What is ibm datastage?
How to perform incremental load in datastage?
Unix command to view the data in a dataset
what is A Datastage?
hi All, i have one scenario like if source--->transformer-->2 target sequential files the 1 st target sequential file is loads the data from source and 2nd target sequntial file contain the 1st target total record count,and file name of 1 st target seq file and timestamp seperated by delimeter for example if source have 10 record the 1st target seq file hav 10 records and 2nd target seq file example 10|xyz.txt|20101110 00:00:00 could you please help me out how can i implement in datastage job.
how to sort two columns in single job in datastage.
What is the difference between datastage and datastage tx?
Teradata 
