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)

Is it passive or active when check and uncheck the box of DISTINCT in Sorter transformation? why?

6 Answers   iFlex, Morgan Stanley,

---

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

0 Answers   CTS,

---

What is joiner transformation?

0 Answers  

---

I want skip first 5 rows to load in to target? what will be the logic at session level ??

1 Answers   IBM,

---

What is informatica etl tool?

0 Answers  

---

---

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

0 Answers  

---

How can you complete unrcoverable sessions?

1 Answers  

---

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

1 Answers   Infinite Computer Solutions,

---

which T/r we can use it mapping parmeter and mapping variable? and which one is reusable for any mapping mapping parmeter or mapping varibale?

3 Answers   Wipro,

---

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

0 Answers  

---

how can u avoid duplicate rows in flat file?

4 Answers   CTS, Wipro,

---

What are partitions in informatica and which one is used for better performance?

2 Answers  

---