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

i have thousand records in my source(flat file) i wanna load 990 records i don't want load first 5 records and last 5 records at informatica level?

3 Answers   Satyam,

---

scenario

1 Answers  

---

What is the need for an etl tool?

0 Answers  

---

what is fact and what types of fact tables is there

4 Answers   Cap Gemini,

---

What is the difference between a router and a filter transformation?

1 Answers   TCS,

---

---

What is workflow? What are the components of the workflow manager?

0 Answers  

---

what is difference between mapping and mapplet ?

2 Answers   TCS,

---

how to declare array in plsql?

1 Answers  

---

Source --------- eno , ename, sal 001,ank,1000 002,behe,2000 003,raj,2500 Target ------- header :DDMMYYYY24MMSS timestamp body: 001,ank,1000 002,behe,2000 003,raj,2500 footer: count(eno),sum(sal) how to implement the same in a FF tgt?

2 Answers   CTS,

---

Explian the connected and unconnected lookup transformation

1 Answers   Informatica,

---

what is the method of error handling when session is running?

1 Answers   TCS,

---

write a query to get maximum salary from the employers table without duplicates....kindly help me

5 Answers   CTS,

---