Answer / ramya

combinality is a mode in Advance tab of a stage.

The mode can have values: Auto, Combinable, Don't Combine.
Auto: let the DataStage decide whether to combine the
stages
Combinable: Combine the operator with other stage if
possible
Don't Combine: do not combine them at all

I think Don't Combine may be non combinability in your
terms.

Answer / sharath s j

Combinability refers to combining operators while running
the job.
EX: Data is read from some table (parallel) Then thru copy
stage u r moving it to another parallel target stage (oracle).

Here the operation of moving thru copy stage will be
combined. When u run the job, you wil not get log entries
for copy stage. And performance stats will not show that the
data is moved to oracle (since copy is combined with oracle)
If you selct "do not combine" in the copy stage, you will
get the logs for copy stage.

Hi guys, 7. how to get this output i/p col1,col2 101,a 102,b 103,c 104,d o/p col1,col2 101,d 102,c 103,b 104,a Thanks

2 Answers   Cap Gemini, IBM,

---

Difference between JOIN,LOOKUP,MERGE?

2 Answers   CTS,

---

HOW CAN WE SEE THE DATA IN DATASET?

4 Answers  

---

What is Horizontal transformation, vertical transformation,diagonal transformation?

2 Answers   Cap Gemini,

---

Please Tell me..,I need some Complex Jobs in datastage as per in interview?how to tell and how to explain?please send as well as posiible please

1 Answers   Systime,

---

how to write server Routine coding?

1 Answers   Eric,

---

How to read multiple files using a single datastage job if files have the same metadata?

1 Answers  

---

Can aggregator and transformer stages use to sort the data? How ?

2 Answers  

---

What is the difference between operational data stage (ods) and data warehouse?

1 Answers  

---

I am having two tables called MASTER and DETAIL. I want to insert records to both tables. But one condition is that whenever the insert for MASTER table is success then only the records will inserted into the DETAIL table, otherwise abort the job. How can u design this job?

1 Answers   TCS,

---

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 &#8722; min_lvl between 0 and 25 inclusive. &#8722; Same column types and headings as Jobs.txt. &#8722; Include column names in the first line of the output file. &#8722; 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 &#8722; min_lvl between 26 and 100 inclusive. &#8722; Same format and derivations as Target file 1. • Target file 3: HighLevelJobs.txt &#8722; min_lvl between 101 and 500 inclusive. &#8722; Same format and derivations as Target file 1. • Rejects file: JobRejects.txt &#8722; min_lvl is out of range, i.e., below 0 or above 500. &#8722; This file has only two columns: job_id and reject_desc. &#8722; reject_desc is a variable-length text field, maximum length 100. It should contain a string of the form: “Level out of range: <min_lvl>”, where <min_lvl> is the value in the min_lvl field. My Question is how do you write the stage variable for reject rows.

0 Answers   HCL,

---

1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do

1 Answers   IBM,

---