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
- 12512 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 informatica? Why do we need it?
r u done any partitions in ur project?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What is the Process to creating lookup transformation in informatica
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
Please let me know how to make encryption and decryption with example?
How to create a non-reusable instance of reusable transformations?
Can you generate sequence numbers without using the sequence generator transformation?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What is a snowflake schema?
When do you use sql override in a lookup transformation?
How to load a Dimension ? and how to load a fact table?
What is informatica worklet?
How would you copy the content of one repository to another repository?
