Answer Posted / subhash

Audit table can be used to check all the details of the
jobs like :
Job status, Last run date
number of rows processed
number os rows entered / rejected in a job,

some companies use shell script to load logs into audit
table & some companies load logs into audit table using
datastage jobs.

Ex:
JOB_DETAIL table, It may contain columns like:
JOB_ID, JOB_NAME, STATUS, JOB_RUN_DT, REC_INSERTED,
REC_UPDATED etc..

What is the difference between datastage and informatica?

1125

---

To see hidden files in LINIX?

1541

---

Difference between server jobs & parallel jobs?

1087

---

What are stage variables, derivations and constants?

1239

---

What is the method of removing duplicates, without the remove duplicate stage?

1034

---

How many Key we can define in remove duplicate stage?

1396

---

how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

816

---

How many areas for files does datastage have?

1163

---

Difference between data warehousing and olap?

1100

---

Why do we use exception activity in Datastage?

1324

---

How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

3471

---

How to RD using transformer?

1433

---

Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

1561

---

what is repositery?

1854

---

i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

3764

---