How to load a relational source into file taget?
Answers were Sorted based on User's Feedback
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 |
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 |
What is a node in Informatica?
What is the Process to creating lookup transformation in informatica
how to run the batch using pmcmd command
Without source how to insert record to target?
How do you change a non-reusable transformation to reusable transformation?
How can we integrate different flat file data in a single mapping and with in a single execution
hw to load this give the mapping? cty state o/p c1 s1 c1 c1 s2 s1 c1 s1 c1 c2 s3 s2 c3 s4 c1 c3 s2 s1 c2 s3 c3 s4 c3 s2 2 columns should be loaded to one column in target table?
Separate from a database, an information bazaar, and an information stockroom?
can we use self join in informaitca?
What is a pre-defined event and user-defined event?
hi all, can anyone tell where i will get good informatica training in Pune? thanks in advance.
write a query to remove null value follwing table? col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output col1 col2 col3 dinesh suresh prakesh