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 .
- 2 Answers
- 9135 Views
- TCS, I also Faced
- E-Mail Answers
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 |
Hi All, I have three question. 1) How to remove the header and footer in a flat file in informatica? 2)How to load the first and last record of flat file into the target? 3)I have a Input and Output table. Input Name Salaray Month A 100 Jan A 200 Feb A 300 March B 400 April B 500 May B 600 June Output Name Salaray Month A 100 Jan A 300 Feb A 600 March B 400 April B 900 May B 1500 June How to implement and get the ouput as mentioned above. If Possible kindly provide the SQL query also. Kindly any one help to implement this concept. Thanks, Pradeep
One source and 3 targets 1st row-1st target 2nd row-2nd target 3rd row-3rd target 4th row-1ist target how will u do?
how can u approach u r client
Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?
What is update override?
Is there any way to read the ms excel datas directly into informatica?
Is it passive or active when check and uncheck the box of DISTINCT in Sorter transformation? why?
6 Answers iFlex, Morgan Stanley,
can any one explain me about junk dimension
What could be the possible resons of locks by user?
What are the popular informatica products?
Why the UNION TRANSFERMATION is an Active TRANSFERMATION
How can repository reports be accessed without sql or other transformations?
Teradata 
