Answer / venkat8510

Please follow the below link, that would be helpful.

https://www.folkstalk.com/2012/05/mapping-variable-usage-example-in.html

how to get flatfile containg 10 records half records one target another half another target

2 Answers  

---

in static and dynamic which one is better

2 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,

---

What are the methods for creating reusable transforamtions?

2 Answers  

---

scenario: dept_no emp_nem 10 A, 10 B, 10 C, 10 D, 20 P, 20 Q, 20 R, 20 S output: dept_no emp_nem 10 A, 10 AB, 10 ABC, 10 ABCD, 20 ABCDP, 20 ABCDPQ, 20 ABCDPQR, 20 ABCDPQRS

1 Answers  

---

---

How you count the number of records available at your source?

3 Answers   Zensar,

---

What are Dimensions and various types of Dimensions?

3 Answers   PayPal, TCS,

---

How will u find weather dimension table is big in size of a fact table?

1 Answers  

---

What are the new features of informatica 9.x at the developer level?

0 Answers  

---

What does “tail –f” command do and what is its use as an Informatica admin.

0 Answers  

---

what is the size of u r source(like file or table)?

0 Answers   HP,

---

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

0 Answers  

---