Answer / vanita

For filtering the data in lookup table using where clause, or joing multiple tables to select data or to change the default order by clause with your own order by clause

How to read data from flat file source if the data is in paragraph format?

2 Answers   Wipro,

---

normalizer transformation

3 Answers   CTS,

---

source : col1 101 101 101 102 102 102 103 103 103 col2 1000 1500 2000 1200 2300 3000 2400 1300 2000 i need target as col1 101 102 103 col2 1000,1500,2000 1200,2300,3000 2400 1300 2000

6 Answers   CTS, Wipro,

---

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  

---

if i am having 10 records in source, i want 20 records in target...how will you do it

13 Answers   BirlaSoft, IBM,

---

What are limitations of joiner transformation?

2 Answers   Exilant, TCS,

---

What is a filter transformation and why it is an active one?

0 Answers  

---

What are the prerequisite tasks to achieve the session partition?

0 Answers  

---

Enlist few areas or real-time situations where informatica is required.

0 Answers  

---

what is bridge tables in informatica

1 Answers   CTS,

---

what is dimension table?

17 Answers  

---

what is Partitioning ? where we can use Partition?

2 Answers   IBM, TCS,

---