two types of data are there . one is mainframe and the other
is ascii format . in informatica how can you get both the
data in a single format in ascii .
Answers were Sorted based on User's Feedback
code page will be used to read/write data properly, w/o
missing anything. To read mainframe data, appropriate code
page needs to be used e.g. ebcdic. Ascii code page will be
used to read ascii format data. Once the sources are
finalized with code pages, then these sources can be used in
mapping. If required normalizer transformation can be used
to read mainframe data. Once required operation is done
through transformation logic then target can be written into
ascii by using ascii code page.
| Is This Answer Correct ? | 3 Yes | 0 No |
if i have a delimited file as source so how can we seperate this file into three diff targets?
What is difference between a gateway node and worker node?
Can anyone tell me, when a flat file contains different kinds of delimeters available for each line ( For Ex: First line contains [,*&#$] and second line contains [%@$#%^]. Like that all records having different kinds of delimeters. How can we implement this kind of flat file in informatica?
ONE FLAT FILE IS THERE WHICH IS COMMA DALAMETED . HOW TO CHANGE THAT COMMA DELEMITER TO ANY OTHER AT THE TIME OF RUNNING ?
Hi Every One When i Start the Workflow, Table is Going to be Stored in the target database But the columns are not going to the target database table in my PC , please give me the solution and waiting for solution
how to load dimension table and fact table. plz tell me the steps.
what is the process of target load planing?
major difference between normal loading and bulk loading?
what is upstream and downstream transformation?
What is aggregate cache in aggregator transformation?
I have 2 Sources,If 1st one Read sucessfully,Then only it has to move to read 2nd source.How can i do in INFORMATICA.
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?