Ypu can write this query in the SQL override. select * from table

How can i send first half of the records to one target and
Remaining to other target?

Question Posted / abhinaw prakash

10 Answers
29265 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / abhinaw prakash

Ypu can write this query in the SQL override.

select * from table_name where rownum < (select
max(rownum)/2) from employees).

Also you can write the same logic in Router and develop a
mapping.

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is session task and command task?

1177

How do you load only null records into target? Explain through mapping flow.

1956

What is a filter transformation and why it is an active one?

906

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

8938

How to join three sources using joiner? Explain though mapping flow.

1090

permutations of mapplet

2454

How to load last n records of file into target table - informatica

1019

What is flashback table ? Advance thanks

1872

How to extract sap data using informatica? What is abap? What are idocs?

1087

without table how to come first record only in oracle?

2205

tell me 5 session failure in real time how can you solve that in your project?

2183

How can we store previous session logs?

989

What is sq transformation?

1080

Which are the different editions of informatica powercenter that are available?

971

What is the difference between Active and Passive transformation?

1081