 Code page compatibly –Where all changes are made to
handle the scenario.
- 1 Answers
- 5680 Views
- DELL, I also Faced
- E-Mail Answers
Answer Posted / mike
when two code pages are compatible then the characters
encoded in the code pages are virtually identical. If the
code pages are identical, then there will not be any data
loss. One code page can be a subset or superset of another.
For accurate data movement, the target code page must be a
superset of the source code page.
Superset - A code page is a superset of another code page
when it contains the character encoded in the other code
page, it also contains additional characters not contained
in the other code page.
Subset - A code page is a subset of another code page when
all characters in the code page are encoded in the other
code page.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is target load order?
Mention a few design and development best practices for informatica?
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.
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
How to configure mapping in informatica?
explain abt ur project architecture?
How many transformations can be used in mapplets.
What are the limitations of joiner transformation?
CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Can we create a Integration service without a Repository service and vice versa?
How to load a Dimension ? and how to load a fact table?
Differentiate between a database and data warehouse?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
What are the tasks that can be performed using sq?
