i have source data like id name sal 1 a 65020 2 b 78250 3 c 58264 but how to get target like this id name sal 1 a Sixty five thousand twenty 2 b Seventy thousand two fify 3 c Fifty eight thousand two sixty four

3 Answers  

---

How union transformation is active ?

2 Answers   Puma,

---

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  

---

In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?

2 Answers   Wipro,

---

followin source like region sales 1 100 2 200 i want the output following format region 1 2 sales 100 200

2 Answers   Oracle,

---

What are the types of lookup transformation?

0 Answers   Informatica,

---

Differentiate between sessions and batches?

0 Answers  

---

Update strategy transformation is an active transformation.How it changes the number of records that pass through it? Please explain....

2 Answers  

---

What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informatica?

3 Answers  

---

In router source is a boy age 20 I given 3 conditions in router a>20, a<=20, a=20 which one exit first?

3 Answers  

---

If one flat file contains n number records., we have to load in target from 51 to 100.. how to use expressions in Informatica..?

2 Answers  

---

Explain about HLD and LLD ?

16 Answers   Accenture,

---