Answer / sudhansu

A mapping which involves with complex Business logic.

Answer / ram kumar

SCD 2 is critical Mapping

source table have single column single record having with single space. load that source record into trg . trgt having two columns and the SOURCE TABLE LIKE COL1 BHANU PRASAD TRGT TABLE COL1 COL2 IN THAT LOAD THE RECORD IN THE trgt table LIKE COL1 COL2 BHANU PRASAD HOW ? TELL ME PLZ

2 Answers   Wipro,

---

Write the prerequisite tasks to achieve the session partition?

0 Answers  

---

source table A having 100000 records. and target B table having 100000 records. now iam updating B records using update query. i don't know which record is update in target. write a sql query get all updated records from target table B.

4 Answers   TCS,

---

hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks... Send me----: raghukrams@yahoo.com

0 Answers  

---

If I am having 6 flat files in data. How can you load the data at a time

2 Answers   CSC,

---

My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?

6 Answers   Accenture,

---

How does the session recovery work.

1 Answers  

---

Quickly characterize reusable change?

0 Answers  

---

What is the reusable transformation?

0 Answers  

---

how can we calculate fact table size?

1 Answers  

---

while creating the scd mappings. we will mention flag value. what exactly the use of defining the FLAG VALUE. Please explaine indetaile

2 Answers   Amdocs,

---

If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?

1 Answers   Amdocs,

---