Answer / subu

For row separation genrally new line is used.
For column separation generally ',' , '|' are used.

Answer / kittu

I think that is delimiters

Answer / vemuri vijay

steps
go to
1.source anlyzer
import from files
then attach your
file
then
select tick the option
import field names from first line

Explain the types of lookup transformation?

0 Answers  

---

explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???

8 Answers   CTS, TCS,

---

what is update strategy transformation ?

7 Answers   TCS,

---

What is a passive transformation?

0 Answers   Informatica,

---

how the data will be loaded while desiging the schema?which one first (for e.g.-dimesions and facts)

2 Answers   Sonata,

---

My sql query is 1. select 1+x from dual? 2. select 1+'x' from Dual? 3. Select x+1 from dual? what is the out put of the above queries?

3 Answers   HP,

---

What is fact table? Explain the different kinds of facts.

0 Answers  

---

source target --------- -------- name no sal name no sal max_sal r 10 1000 r 10 1000 3000 y 20 3000 y 20 3000 3000

7 Answers   Cap Gemini,

---

source is a flat file empname, empno, sal ram, 101, 1,000 sam, 102, 2,000 ques: my target needs the data to be loaded as sal -1000 and 2000 excluding commas target empname, empno, sal ram, 101, 1000 sam, 102, 2000 how to implement this?

5 Answers   Polaris,

---

There are n numbers of flatfile of exactly same format are placed in a folder .Can we load these flatfile's data one by one to a single relational table by a single session??

9 Answers   TCS,

---

What does “tail –f” command do and what is its use as an Informatica admin.

0 Answers  

---

According to his methodology what all you need before you build a datawarehouse

0 Answers  

---