Answer Posted / solomon

2 ways to do it
1- input -> Transformer -> RDP-> output
Sort the input on location, company
do a comparison in Stage Variable with prev record and keep incrementing a counter
pass it via Remove duplicate stage to retain unique records
2- input-> copy-> agrregator-> lookup-> RDP -> output
do the same as above using agg and lookup stage

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

2018

---

How to clean the datastage repository?

1124

---

How do y read Sequential file from job control?

15955

---

Difference between in process and inter process?

1225

---

Differentiate between datastage and datastage tx?

1047

---

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

803

---

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?

2204

---

Where do you see different stages in the designer?

1088

---

What are orabulk and bcp stages?

1119

---

What all are the different way to run a job?

1090

---

What is the difference between datastage and informatica?

1113

---

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

1239

---

What is the difference between informatica and datastage?

1218

---

Nls stands for what in datastage?

1187

---

Explain the situation where you have applied SCD in your project?

2035

---