Answer Posted / ankur saini

hey guys c if this works...

add an exp after source qualifier...with two more ports

v_out as variable =iif((is_number(inputport),0,v_out+1)
output=v_out

so output from this exp will be
1 0
2 0
3 0
* 1
....
* 2
...

now add a filter where output>0

Thanks

What are the tasks that can be performed using sq?

1144

---

What are the new features of informatica 9.x in developer level?

1053

---

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2187

---

Under which circumstances, informatica server creates reject files?

1142

---

i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

2170

---

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1648

---

Difference between Data and Index Caches?

1208

---

What are the different types of repositories created using informatica?

1171

---

What are the components of Informatica? And what is the purpose of each?

1109

---

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4780

---

What do mean by local and global repository?

1282

---

What is fact table? Explain the different kinds of facts.

1126

---

Global and Local shortcuts. Advantages.

2091

---

Implementation methodology

1773

---

How to convert multiple rows to single row (multiple columns) in informatica

1429

---