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

Explain the code page compatibility?

1 Answers  

---

Different types of Power center errors?

1 Answers   Cinterco, IBM,

---

What is a sorter transformation?

1 Answers   Informatica,

---

Briefly describe lookup transformation?

1 Answers  

---

One flatefile it contains some data but i want to dont want to load first and last record ..how it is? can u tell me complete logic?

2 Answers  

---

What is meant by LDAP users?

1 Answers  

---

whether Sequence generater T/r uses Caches? then what type of Cache it is

7 Answers   Accenture,

---

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

7 Answers  

---

To import the flat file definition into the designer where should the flat file be placed?

1 Answers   Informatica,

---

In update strategy target table or flat file which gives more performance ? why?

7 Answers  

---

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

5 Answers   Puma,

---

Can we create two repositories on same database instance in oracle?

1 Answers  

---