Interested to Buy Any Domain ? << Click Here >> for more details...
What are the data movement modes in informatcia?
- 3 Answers
- 7621 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 |
i have flatfile source. i want to load the maximum salary of each deptno into target. what isthe mapping flow
I Have 100 Records in a relational tble and i want to load the record in 3 targets , first records goes to target 1 and second to target 2 and third to target 3 and so on ,what are the tx used in this and what are the logics ,can any one help me ?? Thanks in Advance
If we have 1000 rows were loaded in to datawarehouse and next day the source have 1010 rows so, how can we loaded only updated rows into target.
What is update strategy transform?
What are active transformations? Name them.
Explain Dataware house architecture .how data flow from intial to end?
How to Create a folder using pmrep command?
Is it possible to update the target table with PK?
What is active and passive transformation?
what are surrogate keys?
what is the size of your data warehousing?
Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR How to do the above scenario in Informatica.
Teradata 
