Interested to Buy Any Domain ? << Click Here >> for more details...
If a table contains 100 records we have to fetch 50-100
records from source to target?how
- 7 Answers
- 12541 Views
- CSC, I also Faced
- E-Mail Answers
Answer Posted / udit
If the question is like they want to load next half record then we write query in source qualifier
select * from table
minus
Select * from table
where rownum<=(select count(*)/2 from table)
this query will load the next half i.e. from 50 to 100 records
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the need of an ETL tool?
What is a stored procedure transformation?
What is joiner transformation in informatica?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is informatica? Why do we need it?
What do you mean incremental aggregation?
How do you load alternate records into different tables through mapping flow?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
How does a rank transform differ from aggregator transform functions max and min?
What is a joiner transformation?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
Different circumstance which drives informatica server to expel records?
How to create or import flat file definition in to the warehouse designer?
During the running session, output files are created by informatica server. Enlist few of them.
What is different between the data warehouse and data mart?
