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

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10676

---

how to load dimension table and fact table. plz tell me the steps.

2091

---

What is lookup transformation?

1038

---

How might one distinguish in the case of mapping is right or not without associating session?

1099

---

What is the difference between a repository server and a powerhouse?

1503

---

Explain where to store informatica rejected data? How to extract the informatica rejected data?

1010

---

What is fact table? Explain the different kinds of facts.

1074

---

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

7047

---

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1161

---

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1899

---

What is a repository? And how to add it in an informatica client?

1143

---

Is there any way to read the ms excel datas directly into informatica?

1020

---

Write the unconnected lookup syntax and how to return more than one column.

1105

---

What does command task mean?

1137

---

What are the types of caches in lookup?

1046

---