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

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

0 Answers   TCS, Wipro,

---

Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?

2 Answers  

---

What are 2 modes of data movement in Informatica Server?

1 Answers   Informatica,

---

What are the limitations of joiner transformation?

0 Answers   Informatica,

---

without table how to come first record only in oracle?

0 Answers  

---

What is aggregate cache in aggregator transforamtion?

5 Answers  

---

I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG I need to get max date and its corresponding flag for both the date columns. Ex:- 1A,10/3/2015,AC,10/3/2015,XY 1A,10/4/2015,AB,10/2/2015,XZ Output needed 1A,10/4/2015,10/3/2015,XY I have 100 million + in the table so avoid self-join...

2 Answers   Amex,

---

All active transformations r passive or not?

7 Answers  

---

How to find from a source which has 10,000 records, find the average between 500th to 600th record?

3 Answers  

---

Which are the different editions of informatica powercenter that are available?

0 Answers  

---

Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

0 Answers  

---

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

3 Answers   HCL,

---