Answer Posted / 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

Differentiate between Load Manager and DTM?

2143

---

What is the function of union transformation?

1113

---

What is the difference between router and filter?

1242

---

How are indexes created after completing the load process?

1622

---

What is the sql query overwrite in source qualifier in informatica

1069

---

How would you copy the content of one repository to another repository?

996

---

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1610

---

What are the tuning techniques you applied during your last project

2014

---

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

1911

---

what is diff b/t sorter t/r and agg have the option sorter property...

2161

---

how to create user defined function (udf) in informatica

1288

---

What is flashback table ? Advance thanks

1922

---

Enlist some properties of sessions.

1056

---

wf dont have integration severances how you can run?

1926

---

What is pmcmd command?

1087

---