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 |
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
wat transf shud i use to achieve this id sal id sal sum src-1 20 tgt 1 20 40 1 20 1 20 40 2 15 2 15 35 2 20 2 20 35
Differences between version 7.x and 8.x.
1 Answers Accenture, Cognizant,
Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
what is lookup ?
Define mapping and session?
we have 30 wf with 3 batches means 1batch=10 wf 2 batch=10-20 wf 3batch=20-30wf through unix First you have to complete batch ofter second batch have to run how can you do in unix?
can anyone explain me about retail domain project in informatica?
which is better perfomancewise lookup or joiner and why?can anyone give example?
What are the popular informatica products?
i have an aggregater in my mapping and no group by port on any column and i ampassing 100 rows through aggregater,so how many rows i will get as out put from aggregater