Answer Posted / ramachandra rao.pinninty

In both tables having any common key column use join
stage,other wise in both the tables any columns having same
data type and data length use lookup otherwise that means
there is no common key column,and data length,types are not
same using surrogate key or column generator in both the
tables use join stage.in target it dispaly's 10 fields.

NOTE:the question was little bit clumbsy(there is no clarity)
so these are the way's to solve the senario.

What is the difference between Datastage 7.5 and 7.0?

1050

---

Can you explain link buffering?

1111

---

How do you import and export the datastage jobs?

1109

---

How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?

2550

---

What are stage variables?

1140

---

What is a datastage job?

965

---

How will you move hashed file from one location to another location?

2095

---

How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...

1446

---

How you can fix the truncated data error in datastage?

1677

---

How many types of views are there in a datastage director?

1233

---

What is the difference between informatica and datastage?

1148

---

In Datastage, how you can fix the truncated data error?

1100

---

create a job that splits the data in the Jobs.txt file into four output files. You will direct the data to the different output files using constraints. • Job name: JobLevels • Source file: Jobs.txt • Target file 1: LowLevelJobs.txt − min_lvl between 0 and 25 inclusive. − Same column types and headings as Jobs.txt. − Include column names in the first line of the output file. − Job description column should be preceded by the string “Job Title:” and embedded within square brackets. For example, if the job description is “Designer”, the derived value is: “Job Title: [Designer]”. • Target file 2: MidLevelJobs.txt − min_lvl between 26 and 100 inclusive. − Same format and derivations as Target file 1. • Target file 3: HighLevelJobs.txt − min_lvl between 101 and 500 inclusive. − Same format and derivations as Target file 1. • Rejects file: JobRejects.txt − min_lvl is out of range, i.e., below 0 or above 500. − This file has only two columns: job_id and reject_desc. − reject_desc is a variable-length text field, maximum length 100. It should contain a string of the form: “Level out of range: ”, where is the value in the min_lvl field. My Question is how do you write the stage variable for reject rows.

2673

---

what is use of SDR function?

5128

---

What is the difference between orabulk and bcp stages?

969

---