Answer / ankit gosain

Hi All,

It's a property of DataStage in which it combines two or
more Operators into a single Process.
You can explicitely enable/disable it with the help of
APT_DISABLE_COMBINATION environment variable at the job
level or at the Project level as well.
At stage level also you can enable/disable it:
In Stage properties>> Advance>> Operator Combinality.
By default it's Auto, so that datastage will decide whether
to combine or not.

You can see this combinality behavior by using the
following Environment Variable:
APT_DUMP_SCORE

For further queries, write me @ ankitgosian@gmail.com

Cheers,
Ankit :)

What are stage variables and constants?

0 Answers  

---

How to Remove Duplicate using SQL?

0 Answers   CTS,

---

Can you explain how could anyone drop the index before loading the data in target in datastage?

0 Answers  

---

how to handle null values in sequential file?

1 Answers   HCL,

---

I/P --- ID Value 1 AB 2 ABC 3 ADE 4 A O/p --- ID Value 1 A 1 B 2 A 2 B 2 C 3 A 3 D 3 E 4 A

3 Answers   IBM,

---

---

I HAVE EMP TABLE, 4 COLS R THERE COL1,COL2,COL3,COL4 ID-- 101,102,103,104 SAL-- 1000,4000,2000,5000 DATE-- COLUMN. I WANT TO DISPLAY THE DATA PREVIOUS MONTH HIGEST SAL ?

2 Answers   Wipro,

---

How you Implemented SCD Type 1 & Type 2 in your project?

0 Answers  

---

If there is a file that contains 1000 records, I need the ouput to contain these 1000 records with the header as file name concatenated with the current timestamp and trailer as the count of records

2 Answers   TCS,

---

i have a project manager round on sat this week can you post what are the main question i have to check.if you have any idea regular question on project pls send me. thanks in advance

2 Answers   IBM,

---

eno ename esal acct1 acct2 amount1 amount2 100 suresh 10000 sbi1 sbi2 1000 2000 this is our sourse data i would loke to disply like this eno ename esal acct amount 100 suresh 10000 sbi1 1000 100 suresh 10000 sbi2 2000

2 Answers   HCL,

---

What are the different plug-ins stages used in your projects?

0 Answers  

---

What is the use of hoursfromtime() function in transformer stage in datastage?

0 Answers  

---