Answer / Dilip Kumar Pankaj

In Oracle, common data validations include: check constraints, triggers, and pl/sql procedures. In Informatica, common transformations used for validation include: Conditional Routing (for complex business rules), Lookup (for comparing values to a reference table), and Data Quality Services (for advanced data cleansing and validation).

Explain sessions?

1 Answers  

---

How can we store previous session logs?

1 Answers  

---

If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?

9 Answers  

---

Explain joiner transformation in informatica

1 Answers   Informatica,

---

If you have 10 mappings designed and you need to implement some chages (may be in existing mapping or new mapping need to be designed) then how much time it takes from easier to complex?

1 Answers  

---

we have three columns and two rows. col1 col2 col3 a b c want to change into 2 columns and 3 rows ,how? col1 a col2 b col3 c which transformation u'll use and how?

3 Answers   Cognizant,

---

What are Rapid changing dimensions?

1 Answers  

---

we have a parameter file in Unix location where we have .txt files and those file will be used as source in informatica. I cannot use source file name directly as file name will keep on changing in unix location. I need to define $$InputFile as parameter. Can anybody send me the parameter file and the steps to handle this.

2 Answers   Infosys, TCS,

---

Whether Aggrigator transformation ignore the null values or consider the null values ? Advance Thanks, Manojkumar

3 Answers   IBM,

---

we r using aggregator with out using groupby?

7 Answers   HSBC, Principal Finance,

---

Difference between Target-based loading and constraint-based loading?

1 Answers  

---

Difference Between ETL & ELT?

1 Answers   TCS,

---