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 |
How do you recover rows from a failed session
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
source table have 3 records? and it is sucessfully loaded into target. and 4more records is added in to source .that means 7 records now in source. we have to load the remaining 4 records into the same trgt table with maintian top 3 records. how ?can any one give me the data flow of this logic plz?
what is SDLC way of code development?
what is mystery dimension?
Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?
What is the cumulative sum and moving sum?
What is the difference between Oracle performance and Informatica Percfomance? Which performance is better?
How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?
 Code page compatibly –Where all changes are made to handle the scenario.
I have a source either file or db table Eno ename sal dept 101 sri 100 1 102 seeta 200 2 103 lax 300 3 104 ravam 76 1 105 soorp 120 2 Want to run a session 3 times. First time: it should populate dept 1 Second time: dept 2 only Third time: dept 3 only How can we do this?
What is the difference between Active and Passive transformation?