Answer / sunil

When u want to override the default sql query we will use
sql override

Answer / soujanya

It is a process of writing user defined SQL queries to
define SQL joins,source filters, sorting input data and
eliminating duplicates

Answer / venkateshmalneni

we can write the sql queries in sql override.by using this sql override we can reduce the no of t/r in a mapping.



if no please let me know the correct answer

Answer / chandumba2005

It is a process of defining the user defined SQL queries to filter data, joining the data ,sorting the data and eliminating duplicate records.

have u done any performance tuning? how u ll do?

0 Answers   IMB, TCS,

---

what is surrogatekey ? In ur project in which situation u has used ? explain with example ?

6 Answers  

---

Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

0 Answers   IBM,

---

Explain what is informatica metadata and where is it stored?

0 Answers  

---

How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????

2 Answers   TCS,

---

can we use union transformation in joiner transformation?how?

1 Answers   Dabur, Tech Mahindra,

---

can we have to do changes in session property when we are dynamically generating target files?

3 Answers   Wipro,

---

There are 10 flat files; out of 10 files 1 file is empty. How do you identify the empty file? How can you load all files into targets?

1 Answers   Accenture,

---

How to update or delete the rows in a target, which do not have key fields?

0 Answers   Informatica,

---

TELL ME ABOUT WORK FLOW SCHEDULING?

3 Answers   TCS,

---

What are the transformations that are not supported in mapplet?

0 Answers  

---

Plz can any one say me how to get the informatica certification materials and dumps

0 Answers   TCS,

---