Answer / 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

Answer / nagaraju bhatraju

Target Types are File, Relational and ERP. Latest Answer :
PowerCenter can load data into the following targets:
Relational. Oracle, Sybase, Sybase IQ, Informix, IBM DB2,
Microsoft SQL Server, and Teradata. File. Fixed and
delimited flat file and XML. Application. You can purchase
additional PowerCenter Connect ...

i have a session which creates a file every time when i runs the session, but it replaces the first file with second file,i want to append the second file follwed by first file when i runs the session,how to achieve this?

1 Answers   Thomson Reuters,

---

what type of transformation is not supported by mapplets?

4 Answers   CTS,

---

Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...

1 Answers  

---

Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.

10 Answers   CSC,

---

How can you complete unrcoverable sessions?

1 Answers  

---

i have different sources in different databases ,that sources may be 100 tables i want to load these tables in to single target how to pearform the task

14 Answers   Altisource, TCS,

---

what type of documents you receiving from client later wt can you do? what type of documents have to prepare?

2 Answers   CGI,

---

Describe data concatenation?

0 Answers  

---

Update strategy transformation is an active transformation.How it changes the number of records that pass through it? Please explain....

2 Answers  

---

what is datamart

4 Answers   IBM, Informatica,

---

how the informatica server sorts the strings values in rank transformations?

3 Answers   TCS,

---

What are the reusable transforamtions?

1 Answers  

---