Answer / raji

tq teja.........but its gud if u gave the answer in a proper n clear way..........
plz let me know the process

Answer / ranjan

Please be specific about your requirement. what exactly you want to display in header and footer? So that one can provide you the correct solution.

Answer / teja_dwh

by using session properties we can create header and footers
for flat file.
we can take column names as header etc.

reply me if am wrong
teja_dwh@yahoo.com

In which scenario did you used pushdown optimization?

1 Answers  

---

Differentiate between router and filter transformation?

0 Answers  

---

what are the limitations of pushdown optimization technique ? Advance thanks

3 Answers   Puma,

---

how do u tune queries?

1 Answers  

---

what is the logic will you implement to load data into a fact table from n dimension tables?

4 Answers   TCS,

---

My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?

6 Answers   Accenture,

---

Hi, I am working on informatia in a support role. We used stored procedures in informatica and other than that I never got a chance to work on PL/SQL,little on Unix scripts. But I heard people asking about PL/SQL alot. Can any one let me know how do we use PL/SQL with informatica and if required what is the knowledge that we need to have on PL/SQL? Please let me know in detail which would really help me alot in my career prospectus.

1 Answers   Accenture,

---

My i/p is like below 1,2,3,4,5,6,7,8,9,10....100 I want that to be populated in two o/p as below o/p-1: 10,20,30,40,50,60,70,90... o/p-2: 11,21,31,41,51,61,71,81,91.... How to do it in ingotmatica...

2 Answers   Accenture,

---

I am having a table with columns ID NAME 1 x and the requirement is to get the o/p like this 1 y ID Count(*) 1 z 1 3 2 a 2 2 2 b 3 c so write a sql query to get the id n how many times its count of repetition n there u shouldn't get the distinct(i.e id-3) Reply as early as possible

3 Answers   IBM,

---

why we use datawarehouse

0 Answers   HCL,

---

If I am having 6 flat files in data. How can you load the data at a time

2 Answers   CSC,

---

How to Explain My project flow,In TCS ased me this question. In which way i can start my project flow and they asked how many fact tables and dimensional tables u used. Can any one Explain Briefly for this question and project architecture also.. please..

3 Answers   CTS, HCL, Infosys, TCS,

---