Answer / swetha

When it encounters the DD_Reject in update strategy
transformation.

Violates database constraint

Filed in the rows was truncated or overflowed.

Answer / girish

When the data in the file, may be tab separated, is
incorrect. i.e. if there is an extra tab for a set of
records and this is making the text data come under a
numeric column, this violates the datatype and the source
file is rejected.

my source has 2 columns. 1st column data: ABC ABC ABC XYZ and 2nd column data: 1 2 3 4. And my target should be ABC 1 2 3, XYZ 4

2 Answers   Zensar,

---

If the values in a row are 1,2,3,3,4,,4,5 then how a rank transformation can rank these values

6 Answers   TCS,

---

How to eliminate 1st and last rows from the source and load the inbetween rows.

5 Answers   Syntel,

---

What are the tasks that can be performed using sq?

0 Answers  

---

I have a scenario with lookup table. in that lookup table have colomns, but i need to process only 10 colomns out of 50. Please te me how can we acheive it?

6 Answers   TCS,

---

Can you start a batches with in a batch?

1 Answers  

---

write sql query following source table jan feb mar apr 100 200 300 400 500 600 700 800 900 100 200 300 i want the output format like month total jan 1500 feb 900 mar 1200 apr 1500

3 Answers   Accenture,

---

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

0 Answers   IBM,

---

I HAVE A SOURCE FILE CONTAINING 1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B AND IN TARGET I SHOULD GET LIKE 1|A+B+C+D 2|A+B 3|A+B WHICH TRANSFORMATION I SHOULD USE

5 Answers   Informatica,

---

how to load duplicate row in a target

4 Answers  

---

why we r using presql&postsql in source qualifier?

1 Answers   HP,

---

In CSV flat file date are in the following format. dd/mm/yyyy (05/01/2005)and d/m/yyyy (5/1/2005) and dd/m/yyyy (05/1/2005) and d/mm/yyyy (5/01/2005). It should be load to target in a unique format. How will you implement this?

1 Answers  

---