Answer / sajid

In order to read data from flat file, your must have to be in readable format first. Informatica cannot read/understand the flat file which contains the unstructured data.

By using UNIX shell script or third party tool you will have to bring your data in readable format. When I say in readable format means you will have to use some delimiter in flat file to separate the one column value to another column.

Answer / isha

you can use unstructured data format transformation fro that purpose.

How can we remove the duplicates from flat file source?

0 Answers  

---

What is the difference between source qualifier transformations source filter to filter transformation?

0 Answers  

---

I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<=100 and g2 Sal>=100, first which condition will satisfy, and Why?

11 Answers  

---

How to eliminate duplicates in FF and oracle both

3 Answers   CSC,

---

if i have 10 records in my source,if we use router t/r and given the condition as i>2,i=5 and i<2in the different groups what is the o/p in the target

5 Answers   TCS,

---

i have two source data there is no pk,fk how to join the two sources

5 Answers   TetraSoft,

---

Can you copy the session to a different folder or repository?

1 Answers  

---

what is rank and dense rank in informatica with any examples and give sql query for this both ranks

4 Answers  

---

If the values in a row are 1,2,3,3,4,,4,5 then how a rank transformation can rank these values

6 Answers   TCS,

---

can u give example for factless fact table

2 Answers   TCS,

---

What are the new features of informatica 9.x developer?

0 Answers  

---

How many number of sessions can one group in batches?

0 Answers  

---