Interested to Buy Any Domain ? << Click Here >> for more details...
How can i send first half of the records to one target and
Remaining to other target?
- 10 Answers
- 29583 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / sakthi
i think we can write sql query in first source qualfier and and select another source qualifier and write sql over ride query
1)select * from employees where rownum <= ( select count(*)/2 from employees);
2)select * from employees minus (select * from employees where rownum <= ( select count(*)/2 from employees));
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
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
What is fact table? Explain the different kinds of facts.
How to Create a folder using pmrep command?
What are the mapping parameters and mapping variables?
What is an active transformation?
What does command task mean?
explain about unit testing? in real time?
How you can differentiate between connected lookup and unconnected lookup?
What are the types of caches in lookup?
complex mapping ur project u r invlve can u explain and give real time example give me ?
What is confirmed fact in dataware housing?
What is deployment group?
What is meant by pre and post session shell command?
What is Session and Batches?
Differentiate between Load Manager and DTM?
