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

In which circumstances that informatica server creates Reject files?

2 Answers  

What are the two modes of datamovement in informatica sever?

2 Answers  

What are the steps involved in the migration from older version to newer version of Informatica Server?

0 Answers  

When we enable pushdown optimization technique, two options will be enabled (use view,..). Can anyone tell me how these two options will work ? When do we need to go for pushdown optimization technique ?

3 Answers   IBM,

How you prepared reports for OLAP?

0 Answers  

By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?

14 Answers   CSC, Emphasis,

What are the types of data warehouses?

0 Answers   Informatica,

What do you mean by filter transformation?

0 Answers  

Difference between session variables and workflow variables?

2 Answers   Informatica,

How are the sources and targets definitions imported in informatica designer?

0 Answers   Informatica,

What all are steps in up gradation of Informatica server?

0 Answers  

what is data modelling? what are types of modelling?In which suituation will use each one?

1 Answers   Accenture,

For more Informatica Interview Questions Click Here
Categories