Answer / maruthi

ascii and unicode
ascii-single byte holds all data
unicode-2 byte for each character

Answer / sanjay

ASCII and UNIMODE

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

i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table: pls full details

8 Answers   L&T, TCS, UnitedHealth Group, Wipro,

---

WAT IS TEXT LOAD?

3 Answers   Wipro,

---

how to load the data in fact table.. using look up transformation how to view the second record. usally look up shows matching record for only one value. if i have same value its not displaying. ex: problem i faced. i have total, student no and name in table student i used aggregation transformation to display max(total). i have two same max values in total. when i look up the student name and no for this max(total), its showing only one name and no, its leaving the second one. how to rectify it. plz tel me step by step or clearly.

1 Answers  

---

How to generate a single mapping for both the historical and incremental load.

2 Answers   CSC, TATA,

---

Is LOAD MANAGER AND LOAD BALANCER same in informatica?

1 Answers   KPIT,

---

My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following EmpID, Salary, Composite_Salary- (101, 1000, 1000)(102, 2000, 3000)(103, 3000, 6000). Please guide on how to build the mapping.

5 Answers   Amdocs,

---

What is incremental aggregation and how it is done?

8 Answers   JPMorgan Chase, TCS,

---

what is the process we used in joiner transformation,there is no matching column in sources?

2 Answers  

---

Which is better performance wise database or file?How?

2 Answers   TCS,

---

Why should we use star schema in datawarehouse design?

2 Answers   Wipro,

---

How you load distinct records into one target and duplicate records into another target?

3 Answers   Mphasis,

---

I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in 3rd target? I am new to Informatica,can anybody suggest me the idea?

2 Answers  

---