Answer / ravindra

A transformation is active does not mean that it always
change number of rows. An active transformation can have
passibility to change the number of rows.

In Source Qualifier we can do SQL-override to limit the
number of rows in whare condition, Sorter can remove the
duplicates when select the property checkbox Distinct, In
Router you can only extract the records from selected
(filtered) group. So the number of rows can be impacted.

Expression is an example for passive transformation. Never
change number of rows.

Answer / narender.vankuri

Thank u very much Ravindra

How to load the data from a flat file into the target where the source flat file name changes daily?

0 Answers   Informatica,

---

Target increases every day even though no new record was inserted

0 Answers   Accenture,

---

ename,deptcount vamshi,3 kumar,5 krish,8 in o/p i want vamshi record 3 times kumar record 5 times like wise what is the logic.? give the entire logic plz

1 Answers   IBM,

---

sample mappings for scd1,scd2 and scd3

2 Answers   Cognizant,

---

Hi All, i have question regarding Change Data Capture in Informatica. As i know we can do this using Incremental Aggregation(i never worked on Informatica but i read) and i think we can do the same with SQL Over write and with variables. Can someone tell me how do we do this using other two techniques.. using SQL Over write and variables. Thanks for the help and greatly appreciated.

1 Answers  

---

---

Filter transformation in the condition one of the data is NULL would the record be dropped.

2 Answers  

---

any one can informatica metirial to me ple forwrd to my mail id; gbalireddy@gmail.com

1 Answers  

---

If i have one source having 10 ports.In a mapping i use that source one target having that ten ports.Data from 5 ports are going to target through a mapplet and another 5 ports are going to target through another mapplet.Both 2 mapplets are intially passive in nature.But presently my requirment to convert on mapplet to ACtive.How can i do it.

3 Answers   TCS,

---

i have an aggregater in my mapping and no group by port on any column and i ampassing 100 rows through aggregater,so how many rows i will get as out put from aggregater

5 Answers  

---

wt is the difference between truncate and delete in which situation u use delete and truncate in real time..

4 Answers   TCS,

---

In real time scenario where can we use mapping parameters and variables?

4 Answers   CSC, CSE,

---

What are the types of caches in lookup? Explain them.

0 Answers  

---