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 |
Hello Everyone,i have one question on sequence generator.i have two targets and the records comes from the source will place in the targets like 1-10 rec in target1 and 11-20 rec in target2,21-30 rec in target1...etc so any one can help me? plz..Thanq in adv.
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3
write s sql query following table some duplicate present i want unique one column duplicate another column display? name id a 1 a 1 b 2 b 2 c 3 i want the required output like unique duplicate name id name id a 1 a 1 b 2 b 2 c 3
What is checksum termnology in informatica? Where do you use it ?
3 Answers Chase, Cognizant, Deloitte,
What are the different options used to configure the sequential batches?
Explain about Informatica server process that how it works relates to mapping variables?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Explain joiner transformation in informatica
How to open an older version of an object in the workspace?
Different types of Power center errors?
What is junk dimention?