Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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. How many People are part of your Team? 2. Explain how you create jobs or flow of project? 3. ..

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

Post New Answer

More Data Stage Interview Questions

why we use hash file for lookup?

5 Answers  


what is the difference between the join and look up explin me one exmple

3 Answers  


Can you explain players in datastage?

0 Answers  


What are the different type of jobs in datastage?

0 Answers  


How do u call shellscript/Batch file from DS?

4 Answers   HP,






Which commands are used to import and export the datastage jobs?

0 Answers  


What are the steps required to kill the job in Datastage?

0 Answers  


What is the process of killing a job in datastage?

0 Answers  


j1,j2,j3 jobs r runing iwant to run j1,j3 after j2 how to do this using sequencer? 2)j1,j2,j3 jobs r runing iwant to run j1,j2,j3 how to do this?

1 Answers   Wipro,


Different ways a project can be moved to production ?...example ….export-import and Version control.

0 Answers  


what is combinability and non combinability?

2 Answers  


What are the partition techniques available in your last project?

1 Answers  






Categories