Answer Posted / priyank

select * from (select rownum rn,emp.* from emp) where mod
(rn,2)=1;

Write the prerequisite tasks to achieve the session partition?

1162

---

What are the main issues while working with flat files as source and as targets ?

1167

---

What is a filter transformation and why it is an active one?

970

---

what is index?how it can work in informatica

2044

---

what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

2345

---

Differentiate between sessions and batches?

1023

---

Tell me about Propagate functions in informatica

926

---

i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

2130

---

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

1288

---

hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

2013

---

Explain direct and indirect flat file loading (source file type) - informatica

1321

---

What are the different options available for update strategy?

1005

---

What are the mapping parameters and mapping variables?

1210

---

Differentiate between Load Manager and DTM?

2160

---

list out all the transformations which use cache?

1190

---