if you want to process using unix/linux...we can use head and tail logic t

how will you get 21 to 30 record from 50 records?

Question Posted / rkumar.etl

6 Answers
11693 Views
I also Faced
E-Mail Answers

Answer Posted / rkumar.etl

if you want to process using unix/linux...we can use head
and tail logic to get the records from 21 to 30.

and in informatica we can use rank transformation twice to
get the required results.

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain the features of connected and unconnected lookup.

920

Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

2294

How to extract the informatica rejected data?

1200

What do you mean by blocking transformation?

1016

While migrating the data from one environment to another environment how would you manage the connections?

1074

can you please explain me pre session and post session options?

7519

What is the way to execute pl/sql script using informatica mapping?

1583

CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks

9068

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1105

Have you worked with/created Parameter file

1650

How might one distinguish in the case of mapping is right or not without associating session?

1083

What is blocking transformation?

1127

How do you migrate data from one environment to another?

1080

can anyone suggest best free Talend data integration training online

1683

Write the advantages of partitioning a session?

1259