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

without using rank transformation how can we rank items by using some other transformations

2 Answers  

---

In session log thier should not be a single error how will u do

3 Answers   HCL,

---

Explain the shared cache and re-cache?

0 Answers  

---

WHAT IS THE DIFFERENCE B/W 7.X AND 8.X ? TELL ME FEW DIFFERENCES.

2 Answers  

---

My source is this year 01/jun/2014 04/may/2015 09/mar/2017 my desired output is day month ye 01 jun 2014 04 may 2015 09 mar 2017 how do i acheive this

2 Answers  

---

Can anyone briefly describe abt audit table loading?

2 Answers   TCS,

---

What is Code Page Compatibility?

1 Answers  

---

Session Recovery. 1000 rows in the source of which 500 passed through and then I killed the session. Can you perform a recovery and how

1 Answers   IBM,

---

How many joins in Informatica

5 Answers   CSC,

---

can we override a native sql query within informatica? Where do we do it? How do we do it?

0 Answers  

---

Filter transformation in the condition one of the data is NULL would the record be dropped.

2 Answers  

---

Differentiate between Load Manager and DTM?

0 Answers  

---