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

There are 3 groups in router transformation in which there are no conditions mentioned, so what happens if I connect these groups to the 3 targets? How many records gets into each target.(suppose if we are getting 10 records from the source)

4 Answers  

---

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

0 Answers  

---

Explain the flow of data in Iinformatica?

1 Answers  

---

how many repositories can v create in informatica .

3 Answers   Cap Gemini, Tech Mahindra,

---

what happens when a batch fails?

3 Answers  

---

---

How can yoU create or import flat file definition in to the warehouse designer?

2 Answers  

---

how we can load rejected record's at run time?(not through bad files)

0 Answers   TCS,

---

Define error Threshold?

1 Answers  

---

what is worklet and what use of worklet and in which situation we can use it?

4 Answers   Patni, TCS,

---

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

2 Answers   Zensar,

---

What are the unsupported repository objects for a mapplet?

1 Answers   Informatica,

---

IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP TRANSFORMATION ?

4 Answers   HP,

---