Answer / swetha

Master thread: Creates and manages all other threads

Maping thread: One maping thread will be creates for each
session.Fectchs session and maping information.

Pre and post session threads: This will be created to
perform pre and post session operations.

Reader thread: One thread will be created for each partition
of a source.It reads data from source.

Writer thread: It will be created to load data to the target.

Transformation thread: It will be created to tranform data.

draw informatica architecture 8.6 ?

0 Answers   Cognizant, TCS,

---

Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

0 Answers   IBM,

---

While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?

4 Answers  

---

Explain grouped cross tab?

1 Answers   Accenture,

---

Which transformation should we use to normalise the COBOL and relational sources?

0 Answers   Informatica,

---

---

Q. Informatica workflow, it is running beyond two hours for last couple of runs, normally it completed less then 30 min., hardly 40 min, last couple of run crossing 2 hours and more in that workflow only one session. now it is aasign to you that how to idenitfy the performance issue of the sesion of production.

0 Answers  

---

Scenario is like this: Name Sal A 10; B 20; C 30; Then Output should be Name Sal A 10; B 20; C 30; Total 60; Use SQL For this scenario

4 Answers   TCS, Wipro,

---

write a sql query following table some duplicate present 1 1 2 2 3 3 4 5 i want the output unique one column duplicate another column following format like unique duplicate 1 1 2 2 3 3 4 5

2 Answers   TCS,

---

for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen.

11 Answers   Accenture,

---

When do you use mapping parameters? (In which transformations)

1 Answers  

---

Explain in detail about scd type 1 through mapping.

0 Answers  

---

What is checksum termnology in informatica? Where do you use it ?

3 Answers   Chase, Cognizant, Deloitte,

---