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. can any tell me procedure.

2 Answers   TCS,

---

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  

---

Why touse stored procedure in ETL Application?

2 Answers  

---

What is the difference between lookup override and souce qualifier override ?

2 Answers   Puma,

---

what are factless facts? And in which scenario will you use such kinds of fact tables.

0 Answers  

---

How do you remove duplicate records in informatica? And how many ways are there to do it?

0 Answers  

---

how can we load first and last record from a flat file source to target?

7 Answers   Infosys, ITC Infotech,

---

Hi i am new to Informatica. I have few question's in Informatica. Can any one respond, it will be appricaited. Q.Is Flat File Contains the Dynamic Cache?

6 Answers  

---

Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation

1 Answers   Puma,

---

Can you please mail me a copy of Informatica Certification Exam dumps to sriveniv@hotmail.com

0 Answers  

---

What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?

1 Answers  

---

What are the types of lookup caches?

10 Answers   Accenture, IBM, Informatica,

---