Answer / srinu

--When we load flat files into target tables how do we
identify duplicates?

I have a idea after sql transformation go thruogh 2 Agg
Trans,2 Router Trans
Agg1-gorup by col count=1 to router trans
Agg2-group by col count<>1 to router trans
(I think “it will help u” Any ,,,Let me know,,
srinu.srinuvas@gmail.com)


--where do load the duplicate records for further
reference?

From 2nd router Transfromation we have a Separate Target
Table.

--How do we do chage data capture? Is this Slowly changing
Dimension technique?
chage data capture(CDC) Mean newly Inserts, Updates
Based on Data loading time,,

This Inserts, Updates only Slowly changing Dimension
technique.

Answer / guest

BEFORE LOADING THE DATA IN TO THE TARGET , U CAN CRETAE THE
ROUTER TRANSFORMATION AND PASS THE CONDITION FOR DUPLICATE
ROWS .
YES SCD EXPLAINS THE CHANGED DATA CAPTURE IN TO THE TARGET

Answer / ram

take a router transformation and pass the records through the router transformation and write the logic as if setvarcount()<=1 then send to one target and if setvarcount()>1 then rout them to second target then u can easily avoid duplicates and also u can verify them for future use. try this else correct me

Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please anyone give me a answer with example. Thanks in Advance.

1 Answers  

---

what is polling?

1 Answers   Informatica,

---

111111111111ravi11111111kumar11111111111? i want display ravi kumar using sql?

3 Answers   IBM,

---

In session log thier should not be a single error how will u do

3 Answers   HCL,

---

What is synonym?

2 Answers   Patni,

---

---

What are the different threads in DTM process?

1 Answers  

---

What are the designer tools for creating tranformations?

1 Answers   Informatica,

---

How do you update the records with or without using update strategy?

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,

---

What are the different tools in workflow manager?

1 Answers  

---

What are the restrictions of union transformation?

0 Answers  

---

follwing scenario two table using find maximum salary? table a table b 101 xxx 1000 106 6500 103 yyy 5000 108 800 104 din 6000 109 7000 105 dsh 200 110 3000

5 Answers   IBM,

---