Answer Posted / nagesh

Actually, as said we import data into informatica from
Relational Database sources as well as from Flat File
sources.
A Flat file is a Text file having the data in a different
manner than in the Table.
The data in a Flat file(can be MS Word Doc or Notepad or
any text doc) will be in the form of Fixed width or
Delimited.

Eg of Flatfile

Barak Obama,17,Washington DC,USA OR

01000ScrewDriver009.50{This is fixed
01001Hammer012.95 { width file

What are the different types of repositories created using informatica?

1062

---

Define filter transformation?

1033

---

What is sequence generator transformation in informatica?

997

---

What is the Process to creating lookup transformation in informatica

984

---

Where can we find the throughput option in informatica?

999

---

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

8130

---

What do you mean by enterprise data warehousing?

1002

---

explain about unit testing? in real time?

2140

---

What is a snowflake schema?

927

---

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

1808

---

Write the different tools in the workflow manager?

995

---

How many ways are there to create ports?

1236

---

How do you load alternate records into different tables through mapping flow?

1808

---

Did u used latest transformations of 8.6.0? for what?

1826

---

What is meant by lookup transformation? Explain the types of lookup transformation?

903

---