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

what is the difference between datasatge and datastage TX?

6 Answers  

---

What is RCP

5 Answers   CGI, CTS,

---

file1 1 2 3 4 file2 3 4 5 6 output should be in three targets T1 T2 T3 1 3 5 2 4 6 how to do this? can any one help? Thanks

5 Answers   Cap Gemini,

---

This is UNIX question asked in DataStage Interview. Say I have n numbers of records in a text file. I want first 3 records in 1st file, last three records in 3rd file and remaining n-6 records in 2nd file. (Note: we don't know how many records are there in the File. I am getting one file on daily basis and I want three target files as asked above)

2 Answers   CTS,

---

Hi guys, Design job sequence, we have 3 sources, in that 1st source in abort then only run the remaining sources.. How please design the job. Thanks.

2 Answers   IBM,

---

WHAT ARE PERFORMANACE SETTINGS YOU HAVE IMPLEMENTES IN YOUR PROJECT?

2 Answers   GE,

---

Differentiate between operational datastage (ods) and data warehouse?

0 Answers  

---

What is staging variable?

0 Answers  

---

i want send my all duplicate record one tar and all uniq records one target how we will perfome explain example: input data eid 251 251 456 456 951 985 out put/target1 251 251 456 456 out put/target2 951 985 how we will bring

13 Answers   Bank Of America, IBM,

---

Hi friends, I am new to datastage, i have one query in datastage any one you please give reply to my post. I have a workbook (excel sheet) named as eg: xxxx, in that i have two tables emp(eid, ename, salary, deptno) and dep(deptno, name, state). in my source i have ODBC enterprise stage read the emp table and dept table join the two table and write the dept no 10(eid,ename,salary,name,state) values in target(). Thanks, Badari

0 Answers  

---

In Sequential file, how can i split a column into two, and that column contains string datatype. For Example, i have column of string datatype as subedar khaja. Now i want get output as separately with subedar in one column and khaja in second column. How? Coula anybody, solve it?

2 Answers   Polaris,

---

What is use Array size in datastage

0 Answers  

---