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 |
What aer the out put files that the informatica server creates during the session running?
Three date formats are there . How to change these three into One format without using expression transformation ?
Explain transaction control transformation in informatica
Hi I have two sources like A, B. My source A contain 10000 million records from that i need 20 attributes. My source B has also same 10000 million records from that i need only 1 attribute. By using Joiner i have to load into target? Is there any issue regarding this? if issue is there how to tune this mapping in best way?
Define the various join types of joiner transformation?
what is scd?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
HOW TO YOU LOAD TIME DIMENSION
followin source like region sales 1 100 2 200 i want the output following format region 1 2 sales 100 200
hw cn v elimate dublicate values from lookup without overriding sql?
From where you extract the data, how you did it into informatica? explain....
1 Answers Accenture, Unisoft Infotech,
In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?