Sign Up Login


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

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 .

Question Posted / itsranjan

Answers were Sorted based on User's Feedback



two types of data are there . one is mainframe and the other is ascii format . in informatica how c..

Answer / jayesh m

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

two types of data are there . one is mainframe and the other is ascii format . in informatica how c..

Answer / guest

just selecting Codepage to Ascii

Is This Answer Correct ?    0 Yes 4 No

Post New Answer

More Informatica Interview Questions

can you use flat file for lookup table?why?

2 Answers   HCL,

What is active and passive transformation?

10 Answers  

My source is like bellow F.NAME M.NAME L.NAME A B C D E F G H I and out put should like S.NO F.NAME M.NAME L.NAME 1 A B C 2 D E F 3 G H I 4 UNNOWN UNNOWN UNNOWN How can we acheive? please explane me indetail

2 Answers   Amdocs,

Want to know about Training Centres for Informatica, Cognos and ETL Softwares in Mumbai, India.

27 Answers  

How to load last n records of file into target table - informatica

0 Answers   Informatica,

Howmany ways yoU can update a relational source defintion and what are they?

1 Answers  

I have 2records in target table and this record is deleted in source. Now if I run mapping twice how many records do target will have,  source having 10records. Same with incrementally.  Please  answer me ASAP. 

1 Answers   Cipla, Quintiles,

if i have one mapping and we already tuned that mapping for performance,everything is fine and loading will take 1 hr,so without doing any change in mapping how could we reduce the loading time from 1hr to 1/2 hr.

5 Answers   Wipro,

What are the components of the workflow manager?

0 Answers  

my session have to run Monday to Saturday not run sunday how to sedule in informatica level?

1 Answers   Infinite Computer Solutions,

I have the source like col1 col2 a l b p a m a n b q x y How to get the target data like below col1 col2 a l,m,n b p,q x y

2 Answers   DELL,

HOW TO YOU LOAD TIME DIMENSION

1 Answers  

For more Informatica Interview Questions Click Here
Categories