Answer / Shashi Kant Mishra

The difficulty in working with flat files as source and target in Informatica may depend on the complexity of the data transformation tasks. However, it is important to ensure proper mapping, handling of delimiters, data types, and null values.

What is difference between partioning of relatonal target and partitioning of file targets?

2 Answers  

---

Which transformation should we use to normalise the COBOL and relational sources?

1 Answers   Informatica,

---

what is degenerated dimension?

2 Answers   IBM,

---

On which transformations you created partitions in your project?

1 Answers   Cap Gemini,

---

In aggregator if u enable sorted input what will be the output and disable sorted wt is output

6 Answers  

---

Is there any target staging area in informatica not staging area

1 Answers   Syntel,

---

Tell me one complex query in oracle ?

2 Answers   L&T, Satyam,

---

my session have to run Monday to Saturday not run sunday how to sedule in informatica level?

1 Answers   Infinite Computer Solutions,

---

what are the challenge face in u r project?explain me

1 Answers   iGate, TCS,

---

without matching columns in two tables. how can you join

5 Answers   BirlaSoft,

---

How to eliminate duplicate records in informatica mapping? Explain with an example....

1 Answers   Cap Gemini,

---

I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out

2 Answers   IBM,

---