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
- 12755 Views
- CSC, I also Faced
- E-Mail Answers
Answer Posted / vikash sharma
SELECT * FROM Tab_name
WHERE Record BETWEEN 50 AND 100;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Which means the first record should come as last record and last record should come as first record and load into the target file?
Suppose we do not group by on any ports of the aggregator what will be the output?
What is the benefit of partitioning a session?
While migrating the data from one environment to another environment how would you manage the connections?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is enterprise data warehousing?
How do you take back up of repository?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
Why update strategy and union transformations are active? Explain with examples.
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What is confirmed fact in dataware housing?
How can we use mapping variables in informatica?
How can we update a record in the target table without using update strategy?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What is data movement mode in Informatica and difference between them?
