Answer / prasad_bestha

source table

col1 col2
101 1-a
102 1-a,2-ab
103 1-a,2-ab,3-abc


target table
col1 col2 col3
1 101 a
2 102 a
3 102 ab
4 103 a
5 103 ab
6 103 abc

How you can differentiate between connected lookup and unconnected lookup?

0 Answers  

---

Can you use the maping parameters or variables created in one maping into any other reusable transformation?

1 Answers  

---

Any one can tell me how to explain puss-down optimization ? explain me with example plz?

1 Answers  

---

Hi gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance....

1 Answers  

---

If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?

9 Answers  

---

when we dont use aggregator in mapping ?

2 Answers   CSC,

---

in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?

2 Answers   Cap Gemini,

---

Flat file heaving 1 lack records and I want to push 52000 records to the target?

7 Answers  

---

wht is full process of Information source to target just like stg to productuon and development

1 Answers   Informatica,

---

What is sql query override? When did u use sql query override?

1 Answers   TCS,

---

select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?

5 Answers   Puma,

---

How to recover the standalone session?

2 Answers  

---