Answer / Kunwar Saurabh Singh

Flat file validation in Informatica can be performed using various methods such as data quality rules, custom scripts, or built-in functions like length() and trim(). You can validate the structure and content of your flat files during the transformation process.

when will use SQL override in a lookup transformation?

1 Answers  

---

how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?

1 Answers  

---

What is data cleaning?

1 Answers  

---

what are the production issues in datastage?

1 Answers  

---

what is the difference steps for data modeling?

1 Answers  

---

What is factless fact schema?

3 Answers  

---

what is architecture of your datastage project??? i came across this question many times in interviews in specific what can i answer plz help me.

2 Answers   IBM, Tech Mahindra,

---

give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.

1 Answers   HCL,

---

How to Check the source record count from traget table.

5 Answers   IBM,

---

how do u decide whether u need to do aggregations at database level or at Informatica level?

1 Answers   QualTech,

---

what is the difference steps for data modeling?

1 Answers  

---

Hi please try to reply with answer. my mail id is raghu.1028@gmail.com. if the source is having millions of records, but having theree target tables. As per user the first record need to insert into first target and second record in to a second target and third into third target, similarly the process needs to repeat?

5 Answers  

---