Answer Posted / siri

Hi,

If meta data is same u can achieve this in 2 ways.
1) In job properties -> before job subroutine -> cp file1.txt file2.txt

2) Use Funnel

Meta data is not same then you need key.(With out key it is not possible)

What is aggtorec restructure operator?

731

---

why do u need the IOS upgradation in a FC switch

1878

---

How do you schedule or monitoring the job?

675

---

State the difference between an operational datastage and a data warehouse?

613

---

how to abort the job its matain duplicates?

2110

---

---

file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

545

---

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

2997

---

Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

1766

---

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 ?

1638

---

EXPLAIN SCD

973

---

How to RD using transformer?

868

---

1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.

3505

---

Difference between data warehousing and olap?

655

---

Different ways a project can be moved to production ?...example ….export-import and Version control.

1941

---

What are some different alternative commands associated with "dsjob"?

663

---