what is combinability and non combinability?
Answers were Sorted based on User's Feedback
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.
| Is This Answer Correct ? | 5 Yes | 0 No |
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.
| Is This Answer Correct ? | 4 Yes | 0 No |
what is factless fact table?
Hi I am Vijay In my source i've 10 records in a single column.... but i want to split those records into 5 sequential files each seq file contains 2 records.?.... can any body help me?
15 Answers Scope International,
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
1)What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?
1) In a dataset how to delete a single row? 2) i have 50 rows , i want to display 5-7 records only? How to write the sql query? 3)i have 40 rows,i want to display last row? write sql query?
What is the use of Row generator stage?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
HOW CAN YOU DO SCD2 IN DATA STAGE USING SEQUENTIAL FILES?
why we use parameters instead of hard code in datastage
How to add zero "0" before record in a field?
Can you explain how could anyone drop the index before loading the data in target in datastage?
client know skid info?