What are the data movement modes in informatcia?
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 |
If we have a two tables A & B A contain 10 records,B contain 20 records,what w'll b the o/p if we perform normal join,Master outer join,Detail outer join and Full Outer join how?
Without using any transformations how u can load the data into target?
What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?
How can a transformation be made reusable?
Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?
Explain the etl program with few examples.
waht is dataware house
how to return multiple columes through through un-connect lookup?
who to split dimentions into sub dimention
how to improve performence by using sorted input in aggrigator t/r.
What are the different types of code pages available in informatica & how to implement it in your project?
Had any one faced informatica(ETL/Developer), Datawarehouseing interview in UK. Than plz help me (i have any exprience of 3yrs informatica,datawarehousing,oracle,teradata) 1.hw the procedure will b here 2. wht type of question's they will b asking. 3.In which area they concertate more. since this is the first time im facing interview in UK. plz help ASAP.it will b a great help for me thanks to All in Advance