Answer / yash

There are many ways to check this:
1. Do Column level check meaning SRC.ID=TGT.ID but others
columns are not matching on data.
2. you can do MINUS (SRC MINUS TGT) and (TGT MINUS SRC)for
particular day's load.
3. you can do referential integrity check by checking any id
valus in SRC but not in TGT or any id in TGT but not in SRC.

Hope these are enough.

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

2 Answers   CTS,

---

Can anyone please help me out,In which transformations records will be rejected and how capture those records?and How to reload the rejected records?

3 Answers   Syntel,

---

We can achieve better perfomance using sorter before an aggragator. Then what is the significance of 'Sorted Input' check in aggregator ?? Please let me know the difference ??

2 Answers  

---

what is normalizer transformation?

4 Answers   Wipro,

---

If we are using an aggregator but forget to mention the group by port .what will be the output??

11 Answers   Nomura, TCS,

---

What is Java Transformation? what are the uses of it?

0 Answers   TCS,

---

Can i create a lookup table without cache.

7 Answers   iGate,

---

Can we create out put ports in source qualifier t/r?

5 Answers   TCS,

---

I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.

3 Answers   Amdocs,

---

What is exclusive and normal mode for repository services?

0 Answers  

---

what is unit testing?tell me proceedure

0 Answers   L&T, UST,

---

Two Default User groups created in the repository are ____ and ______

2 Answers  

---