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 |
My source has 100 records. I have targets say in number 5. all target tables has parent and child relationships in between themselves. Now I want to load all 100 records into all targets. How U can ensure that record inserted in parent and then loaded into child.
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Explain the informatica workflow?
What is rank index in rank transformation?
If informatica has its scheduler why using third party scheduler?
can every transfomation reusable?how?
hw cn v elimate dublicate values from lookup without overriding sql?
Explain the shared cache and re-cache?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
how to load dimension table and fact table. plz tell me the steps.
every DWH must have time dimension so now what is the use of the time dimension how we can calculate sales for one month,half-yr'ly,and year'ly?how we are doing this using time dimension.
If I have a index defined on target table and if set it to bulk load will it work ?