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 ...

What is the difference between writing a joiner query in ANSI style and THETA style?

0 Answers   TCS,

---

tell me the informatica architecture

1 Answers   Banca Sella, Wipro,

---

How do you take care of security using a repository manager

2 Answers  

---

Define mapping and session?

0 Answers   Informatica,

---

Tell me about Propagate functions in informatica

0 Answers  

---

What do think which one is the better joiner or look up?

0 Answers  

---

In router source is a boy age 20 I given 3 conditions in router a>20, a<=20, a=20 which one exit first?

3 Answers  

---

Does Facttable Normalized or Denormalized?

2 Answers   IBM,

---

Which transformation is needed while using the Cobol sources as source definitions?

0 Answers   Informatica,

---

while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?

1 Answers   IBM,

---

who to split dimentions into sub dimention

3 Answers   Wipro,

---

What is the session task and command task?

0 Answers  

---