Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

How to load a relational source into file taget?

Question Posted / laxmanl

Answers were Sorted based on User's Feedback



How to load a relational source into file taget?..

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

Is This Answer Correct ?    3 Yes 0 No

How to load a relational source into file taget?..

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

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

What is partioning?how many types of partinings are there

2 Answers   HCL,

How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.

1 Answers  

Which development components of informatica have the highest usage?

0 Answers  

how can send duplicate records to one tableand non duplicate records to one table with simple clear mapping?

5 Answers   DELL,

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

0 Answers   TCS,

what are the deliverables?in your project?

0 Answers   DELL,

What are the types of groups in Router transformation?

1 Answers   Informatica,

what is tha tracesing level? and difference betweentrace in normal and verbose and nonverbose?

2 Answers  

Discuss the advantages & Disadvantages of star & snowflake schema?

5 Answers  

how to sort date field in infomatica?

2 Answers  

how remove 1st 3 records & last 3 records in informatics

4 Answers   TetraSoft,

What differs when we choose the sorted input for aggregator transformation?

0 Answers  

For more Informatica Interview Questions Click Here
Categories