Answer / rohan

in SCD2, the flag value indicates whether the record is the active record(Current version of the record) or not.

Answer / kishor baindoor

In SCD each record is flaged in mapping logic so that
record will either inserted or upated or deleted
accordingly. You can flag record as 'I' or 'U' or 'D'

Explain transaction control transformation in informatica

0 Answers   Informatica,

---

My source has 100 records. I have targets say in number 5. all target tables has parent and child relationships in between themselves. Now I want to load all 100 records into all targets. How U can ensure that record inserted in parent and then loaded into child.

3 Answers   Cognizant,

---

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

4 Answers   TCS,

---

Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

0 Answers   Informatica,

---

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,

---

---

what are the transformations that restricts the partitioning of sessions?

1 Answers  

---

we have 6 records in source , i need 2nd record in one target and 5th record in one target or 2nd & 5th record in same target.

8 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,

---

What is blocking transformation?

0 Answers   Informatica,

---

How to join a Flat and Relational Source without using (Joiner, Update and Lookup ) transformations... is it possible? if yes i would like to know how?

10 Answers   Wipro,

---

what is the difference between informatica6.1 and infomatica7.1

0 Answers   TCS,

---

what is pre and post sql and what is diff between source presql and target pre sql

1 Answers   HCL, IBM,

---