If a table contains 100 records we have to fetch 50-100
records from source to target?how
- 7 Answers
- 10218 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
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
Could you explain what is enterprise data warehouse?
What are the components of Informatica? And what is the purpose of each?
Define the various join types of joiner transformation?
What are batches?
What is difference between a gateway node and worker node?
Explain constraint based loading in informatica
What is meant by target load plan?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What is dimensional table? Explain the different dimensions.
What is meant by query override?
What are roles and groups and benefits of using them?
What is the sequence generator transformation in informatica?
What is xml source qualifier transformation in informatica?
How can we remove the duplicates from flat file source?
