When you connect to repository for the first time it asks you for user name & password of repository and database both. But subsequent times it asks only repository password. Why?

1 Answers  

---

What are the reusable transforamtions?

2 Answers  

---

How to delete the (flat file) data in the target table after loaded.

2 Answers   TCS,

---

For stage table data processing, suppose in first run we processed 8 records out of 10 records then in 2nd run we should consider only not processed records (here total no of records =2) along with new records which got loaded in stage table thru real time mapping. Note : In this example, 8 records are those records for which we got transaction number after lookup on trn_no_cod table and 2 records for which lookup returns trn_no as NULL

1 Answers  

---

Differentiate between a repository server and a powerhouse?

0 Answers  

---

---

What are roles and groups and benefits of using them?

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,

---

Is it possible to define a single node as a Gateway node as well as worker node?

0 Answers  

---

If a session fails after loading of 10,000 records in to the target.How can you load the records from 10001?

5 Answers   TCS,

---

Explain factlessfact table with scenario

1 Answers   HCL,

---

How to differentiate between the active and passive transformations?

0 Answers  

---

Please create a mapping where I have source which has one column with name like Aman_Gupta Rakesh_Mehra Sachin_More I want the target field should contain the name in reverse order i.e Gupta_Aman Mehra_Rakesh More_Sachin. Can you please tell me what transformation would be needed to do this.

5 Answers  

---