Answer / guest

Two modes of data movement are ASCII mode and uni code

Answer / pradeep

Bulk Mode and Normal Mode

write a query for how to eliminate the duplicate rows without using distinct?

6 Answers   iGate,

---

differences between service based and product based?

0 Answers   Satyam,

---

How can we get multiple output values using an unconnected lookup transformation?

2 Answers   TCS,

---

HOW TO GET THE LATEST DATA IN SCD ?

4 Answers   TCS,

---

What differs when we choose the sorted input for aggregator transformation?

0 Answers  

---

---

how to read data from website into informatica? plsss send answers ASAP thanks in advance.

1 Answers   DELL,

---

i have two sources two flatfiles same structure one flatfile contain 100 million recs another flatfile contain 10 million recs i have to connect single target(performance oriented answer) what are the steps we have to do this scenario

4 Answers   Polaris,

---

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,

---

I have 2records in target table and this record is deleted in source. Now if I run mapping twice how many records do target will have,  source having 10records. Same with incrementally.  Please  answer me ASAP. 

1 Answers   Cipla, Quintiles,

---

What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

0 Answers   IBM,

---

In a concurrent batch if a session fails, can you start again from that session

1 Answers  

---

how many tasks are there in informatica ?

15 Answers   DELL, iGate, TCS,

---