Answer / qlikstar

select 150 from tab
Ans:150
150
150
--
--
150(200 times)

Answer / babu

Hi all,

it is very simple.

if you give any number in the select list it will displays the
that number(how many records table havie that number of times)

Ex: select 200 from tab
Ans:200
200
200
--
--
200(200 times)

If you want to create indexes after the load process which transformation you choose?

3 Answers   HCL,

---

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

0 Answers   TCS, Wipro,

---

I am having a FLAT FILE 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 to a FLAT FILE only.For more clarification i want to elimate nulls and want in a single line. Please help me out

5 Answers   IBM,

---

What is meant by lookup transformation?

0 Answers  

---

How can you run a session without using server manager?

1 Answers  

---

To import the flat file definition into the designer where should the flat file be placed?

0 Answers   Informatica,

---

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

0 Answers   TCS,

---

select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?

5 Answers   Puma,

---

how can we convert a column into row in informatica? Eg: INPUT- a x Output Like: a b c b y x y z c z

3 Answers   CTS,

---

WHAT IS USE OF SQL OVERRIDE IN SOURCE QUALIFIER? chandumba2005@gmai.com

2 Answers   TCS,

---

In CSV flat file date are in the following format. dd/mm/yyyy (05/01/2005)and d/m/yyyy (5/1/2005) and dd/m/yyyy (05/1/2005) and d/mm/yyyy (5/01/2005). It should be load to target in a unique format. How will you implement this?

1 Answers  

---

What is complex mapping?

0 Answers  

---