Answer / gazulas

man!! u can flag the record as insert or reject.

Answer / raghav

Following options are available for update strategy :

DD_INSERT : If this is used the Update Strategy flags the row for insertion. Equivalent numeric value of DD_INSERT is 0.
DD_UPDATE : If this is used the Update Strategy flags the row for update. Equivalent numeric value of DD_UPDATE is 1.
DD_DELETE : If this is used the Update Strategy flags the row for deletion. Equivalent numeric value of DD_DELETE is 2.
DD_REJECT : If this is used the Update Strategy flags the row for rejection. Equivalent numeric value of DD_REJECT is 3.

so u can use update strategy for delete, reject or insert.

I am hvaing SOURCE as 1000,null,null,null null,2000,null,null null,null,3000,null null,null,null,4000 Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out

5 Answers   IBM,

---

During the running session, output files are created by informatica server. Enlist few of them.

0 Answers  

---

111111111111ravi11111111kumar11111111111? i want display ravi kumar using sql?

3 Answers   IBM,

---

Target is zero file and how can you send the email?

2 Answers   Bank Of America,

---

Describe two levels in which update strategy transformation sets?

1 Answers  

---

Scenario is like this: Name Sal A 10; B 20; C 30; Then Output should be Name Sal A 10; B 20; C 30; Total 60; Use SQL For this scenario

4 Answers   TCS, Wipro,

---

How to fix the etl bugs..Tell me the process?

1 Answers   IBM,

---

What is a dimensional model?

0 Answers  

---

Suppose we have a (assume relational) source table Product_Id Month Sales 1 Jan x 1 Feb x . . . . . . 1 Dec x 2 Jan x 2 Feb x . . . . . . 2 Dec x 3 Jan x 3 Feb x . . . . . . 3 Dec x . . . . . . and so on. Assume that there could be any number of product keys and for each product key the sales figures (denoted by 'x' are stored for each of the 12 months from Jan to Dec). So we want the result in the target table in the following form. Product_id Jan Feb March.. Dec 1 x x x x 2 x x x x 3 x x x x . . So how will you design the ETL mapping for this case , explain in temrs of transformations.

5 Answers   Accenture, VAMA,

---

write a query to get maximum salary from the employers table without duplicates....kindly help me

5 Answers   CTS,

---

What is the use of code page?

0 Answers  

---

what is incremantal aggregation?

1 Answers  

---