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

What are the join types in joiner transformation?

1 Answers   Informatica,

---

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

2 Answers   Bank Of America,

---

what is the diff b/w target load plan and cbl?

3 Answers   CTS, iGate,

---

why sequence generator should not directly connected to joiner transformation ?

1 Answers   ANZ,

---

if we are extracting 600000 records from a source table so how much volume of records frequently we load in warehouse. (Iknow its depend on client requirement) still i want to know how much volume of records store in warehouse.

2 Answers   IBM,

---

if we r using aggregator we enabled sorted input but the records r not sorted what happen?

7 Answers   HSBC,

---

What is batch and describe about types of batches?

2 Answers  

---

how to get the data from the client machine and how to get server location data to client loction can any body explain to me

1 Answers   TCS,

---

we have tables like c1 a c2 b c3 c c4 x c5 y and i need output like abcx in a single row and abcy in a single row? how do u do this?

2 Answers   Patni, Tech Mahindra,

---

Explain the scenario which compels informatica server to reject files?

0 Answers  

---

What are the challenges of Dataware housing in the future?

2 Answers   HP,

---

How to recover sessions in concurrent batches?

1 Answers  

---