Answer / brajesh kumar

In most of the cases we dont have the required data in one
schema and it should nt be if its not of same level of
importance. comming to ur question,we can 2 cases:
1. if both schema are present in same database instance.
2. if both schemas are on different database instance.
for 1. we can access data from any schema via sql query
within dtabase connection stage on datastage. the sql
structure wud be according to the required output.

for 2nd one. we need to use 2 database stage and then via
join or other database filter stages u can get ur desired
output.

Answer / nish

since you know the schema already use the modify stage and also make sure that RCP is enabled.
This will help you ensure you get the columns you need.

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  

---

How can we run same job in 1 day 2 times

7 Answers   IBM,

---

What is the purpose of interprocessor stage in server jobs?

0 Answers   ASD Lab,

---

Difference between in process and inter process?

0 Answers  

---

Source have 1000 records and it can have three nodes ok but i want how many records are executed on each node?

3 Answers   TCS,

---

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,

---

1)How to do error handling in datastage? 2)Did sequential stage accepts .xl files ,xml? znd how?

2 Answers   UHG,

---

when will you go for dataset and fileset?

2 Answers   Accenture,

---

what is meta data? Explain? Where it is used?

9 Answers  

---

5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10

2 Answers  

---

Unix Qn asked in datastage interview: I have diff type(.txt, .tmp, .bat etc) of file in 4 diff directories, I want move all '.txt' file from 4 directories to other folder. And need to delete all the files except which are created TODAY?

2 Answers   TCS,

---

can explain wt is the pool for file.

1 Answers   CTS,

---