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.

What are the issues that you have faced while moving your project from the Test Environment to the Production Environment?

1 Answers  

---

suppose we will take flatfile target and load type is bulkload the session fails why please give me the answer

1 Answers   TCS,

---

What is Performance tuning in Informatica?

1 Answers   CTS, GE, TCS,

---

How the dimensions will be loaded?

0 Answers   HCL,

---

Which development components of informatica have the highest usage?

0 Answers  

---

What is workflow? What are the components of workflow manager?

0 Answers  

---

how can u avoid duplicate rows in flat file?

4 Answers   CTS, Wipro,

---

What is the difference between sequential batch and concurrent batch and which is recommended and why?

1 Answers  

---

Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance

3 Answers  

---

tell me some dimension tables names in banking domain informatica project(dont tell like depends on project, tell me names of dimension and fact table names in your project)?

3 Answers   IBM, Patni, TCS,

---

If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?

4 Answers  

---

What is update strategy transform?

0 Answers  

---