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
- 29703 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
Design a mapping to load the cumulative sum of salaries of employees into target table?
What do you understand by a term domain?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What are the different versions of informatica?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
How do you load unique records into one target table and duplicate records into a different target table?
What is update strategy transform?
Why do you use Mapping Parameter and mapping variable?
What are junk dimensions?
What is dimensional table? Explain the different dimensions.
What is informatica?
What is informatica? Why do we need it?
Enlist the tasks for which source qualifier transformation is used.
what is the -ve test case in your project.
