in rownum not support grater than so use in filter transformation iif(rown

If a table contains 100 records we have to fetch 50-100
records from source to target?how

Question Posted / rajesh

Answer Posted / rajesh

in rownum not support grater than so use in filter
transformation iif(rownum<50,false,true)

Is This Answer Correct ?

1 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What are the uses of etl tools?

1065

suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

2078

What is a sorter transformation?

1037

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

1010

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

1195

tell me about your project functionality

2294

How to update or delete the rows in a target, which do not have key fields?

1116

How to elaborate powercenter integration service?

1072

How to go to the older version for a mapping?

1028

Please let me know how to make encryption and decryption with example?

1847

update strategy transformation in informatica

1014

What is an expression transformation in informatica?

963

What are the databases that informatica can connect to windows?

1001

Why update strategy and union transformations are active? Explain with examples.

1173

What is repository manager?

930