Answer / smarati

It is active transformation because,

- we can do sql override
- select distinct option, which reduces the number of rows.
- we can use join condition

All the above increases/decreases the number of rows, so SQ
is active.

Thanks
Som

Answer / sushma

SQ transofrmation reads the rows from the source. It is an
active transformation.

Source (Flatfile) - Target (1-1 mapping). How to load first or last 20 record to target?

5 Answers   Flextronics,

---

Informatica software installation 8.1/7.1.3/7.1 with oracle 10g database (optional Teradata v2R6)

1 Answers  

---

What are the tasks that can be performed using sq?

0 Answers  

---

how many new transformations are introduced in 8.1 which are not available in 7.1? any new transformation in 8.6?

2 Answers   emc2,

---

What is a stored procedure transformation?

0 Answers  

---

---

How to handle changing source file counts in a mapping?

3 Answers   Deloitte, TCS,

---

what is the diff b/w cached and unchaed look ups

3 Answers   IBM, TCS, Wipro,

---

Can anyone briefly describe abt audit table loading?

2 Answers   TCS,

---

Quickly characterize reusable change?

0 Answers  

---

How many repositories can we create in Informatica?

3 Answers  

---

my source is a comma delimited flatfile as eno, ename, sal 111,sri,ram,kumar,1000 and my target should be eno ename sal 111 sri ram kumar 1000 i.e; we need to eliminate the commas in between the data of a comma delimited file.

5 Answers   IBM,

---

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

0 Answers   TCS,

---