What are the data movement modes in informatcia?
- 3 Answers
- 6947 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / maruthi
ascii and unicode
ascii-single byte holds all data
unicode-2 byte for each character
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / abeer
ASCII mode - Used when all sources and targets are 7 - bit
ASCII or EBCDIC character set. It stores each character in
a single byte.
Unicode Mode - Used when source and target use 8 -bit or
multibyte character set and contains character data
| Is This Answer Correct ? | 1 Yes | 0 No |
what is the incremental agrrigation?
can we override a native sql query within informatica? Where do we do it? How do we do it?
What is the difference between Connected and UnConnected Lookup Transformation.Give me one or two examples please?
After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?
i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c i want output as 1 a,b,c and 2 a,b,c ... how can achieve this
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is fact table? Explain the different kinds of facts.
Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3
How to create or import flat file definition in to the warehouse designer?
In Datastage, we have row generator stage to generate dummy row. Is there any such transformation in Informatica. Thanks in advance, Kumar
SO many times i saw "$PM parser error " .what is meant by PM?
Teradata 
