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 |
Explain about cumulative Sum or moving sum?
Scenario is like this: Name Sal A 10; B 20; C 30; Then Output should be Name Sal A 10; B 20; C 30; Total 60; Use SQL For this scenario
If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?
Hi, I am unable to connect ports from two Active trasformations to another active transformation ? Why is it so? Why it is designed like that? Some rules has been designed like this that is We can't connect passive and another passive to active.Can any one please letme know all these rules. Ex:- I am trying to connect filter1 and filter2 to another filter. Please answer me Advance Thanks
Can we create a node as a gateway node and the same node can be assigned to a grid?
how to read data from website into informatica? plsss send answers ASAP thanks in advance.
What is the procedure to load the fact table.Give in detail?
why we use materialized view over view?
my source having 10 records but how can i load 20 records in target, i am not bother about duplicates?
In real time scenario where can we use mapping parameters and variables?
What is a joiner transformation and why it is an active one?
If u r using dynamic cache lookup port will be thier in thet which option u will select