Answer Posted / subhash

1. SRC---->TFM---->TGT
in the TFM, by using Looping we, can do this.
@ITERATION<=5

2.SRC---->COPY===>(5copies/links)==>FUNNEL---TGT

take 5 output links from copy stage, pass those to Funnel
then you will get the desired output.

3. SRC--->TGT
run the job 5 time in 'APPEND' mode

what is 'reconsideration error' and how can i respond to this error and how to debug this

2557

---

How do you schedule or monitoring the job?

1135

---

What are the repository tables in datastage?

1259

---

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

725

---

What is the purpose of pivot stage and types of containers in datastage

996

---

To see hidden files in LINIX?

1454

---

Is possible to create skid in dim,fact tables?

2590

---

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

1233

---

Notification Activity

1350

---

What is the difference between odbc and drs stage?

1045

---

What is orabulk stage?

992

---

In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

1452

---

how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

3266

---

How do you reject records in a transformer?

1061

---

8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

2156

---