Answer Posted / deepu

The good advantage of using Informatica it enables to work
with both relational and non-relations source and targets.
So , now to load a data from relation to flatfile follow
the steps:
1,Extract the Sourec table (i.e orcale, teradata any
reational)
2, create a target table (FlatFile) let it be fixed with r
delimiter as per the data in the source table then creat
the columns and make the point that the datatype must match
to that of the datatype in the source table .
3, Built a mapping considering the needed
transformations .
4, configure the source and target in the workflow manager .
5 . and execute the job....
check out properlly the properties setting at workflow
manager .

Thanks & Regards
Deepu

What happens to map if we alter the datatypes between source and its corresponding source qualifier?

1044

---

What is an Integration service in Informatica?

1128

---

How do you load only null records into target?

1212

---

what is the hint? how to use it to reduce the query processing in program?

7816

---

How can we use mapping variables in informatica?

1061

---

Performance tuning in UNIX for informatica mappings?

2566

---

What are the limitations of joiner transformation?

1105

---

How to load a Dimension ? and how to load a fact table?

1408

---

Is there any target staging area in informatica not staging area

2576

---

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1121

---

Explain incremental aggregation in informatica

1122

---

In development project what is the process to follow for an etl developer from day1

1718

---

What will be the approach?

977

---

What are the mapping parameters and mapping variables?

1198

---

Explain pmcmd command usage in informatica

1127

---