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

in reporting we add some new objects,how we get the count of the newly added objects to the report

2202

What is different between the data warehouse and data mart?

1078

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1133

Implementation methodology

1723

Differentiate between a database and data warehouse?

1151

Difference between Data and Index Caches?

1145

What is an Integration service in Informatica?

1143

Which transformation is needed while using the Cobol sources as source definitions?

1179

How many transformations can be used in mapplets.

1944

hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

2016

Explain target update override in informatica

1133

how to load rows into fact table in data warehouse

1199

Explain in detail about scd type 1 through mapping.

1564

What is a code page?

1183

What are the main features of Oracle 8i with context to datawarehouse?

2116