What are the different types of code pages available in
informatica & how to implement it in your project?
Answer / mitali awasthi
What is code page in informatica
The code page in informatica is used to specify the
character encoding. It is selected based on the source
data. If the source data contains japanese characters, then
the code page is selected to support japanese text. When a
code page is chosen, the program or application for which
the code page is set, refers to a specific set of data that
describes the characters the application recognizes. This
influences the way that application stores, receives, and
sends character data.
Most commonly selected encoding systems are:
ASCII
UTF-8
UTF-32
| Is This Answer Correct ? | 2 Yes | 0 No |
Explain the code page compatibility?
What are the measure objects?
can every transfomation reusable?how?
source target Q410 4 2010 Q311 3 2011 Q412 4 2012 Q309 3 2009
What is dynamic cache?
Suppose we have a csv file with contents as below which is used has a source file. C1,C2,C3,C4 100,200,A B,300 200,400,X,Y,299 ---> it should be 4 values but by mistake 300,600,C D,566 with a comma in between X & Y,its 5. My target takes only 4 columns, How to take care of the 2 record as above without rejecting it and loading in the target. Hope u guys have understood my scenerio
Data transformed successfully from Source table to target table. Now how you will ensure that the data in Target table is proper. I answered will verify one or two records and check Then question was that the Development is doing (1-2 record verification)but as a tester you have to verify the complete data, how you will do?? Please answer
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
What are connected or unconnected transformations?
If session fails after loading 10000 records in the target,how can we load 10001 th record when we run the session in the nexttime?
Can any one give me an example for factless fact table ? If your answer is studunt attendence registration,could you plese give me explanation for this ?
3 Answers Cap Gemini, Puma, Wipro,
How do you load first and last records into target table?