we have 1 source table containing 100 records. now we have to transfer fi

Advertise your Business Here

Refer this Site

Login | Sign Up


	Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff HERE

Categories >> Software >> Data Warehouse >> ETL

Teradata Interview Questions

Business Objects Interview Questions

Cognos Interview Questions

Informatica Interview Questions

Crystal Enterprise Suite Interview Questions

Actuate Interview Questions

Ab Initio Interview Questions

Data Stage Interview Questions

SAS Interview Questions

Micro Strategy Interview Questions

ETL Interview Questions

Data Warehouse General Interview Questions

Question

we have 1 source table containing 100 records. now we have 
to transfer first set of 1-10 (i.e1-10) records to one 
target table and another set of 1-10(11-20) records to 
other target table and continue like that till 100th record

Question Submitted By :: Coolani

I also faced this Question!!

Rank

Answer Posted By

Re: we have 1 source table containing 100 records. now we have to transfer first set of 1-10 (i.e1-10) records to one target table and another set of 1-10(11-20) records to other target table and continue like that till 100th record

Answer
# 1

we can use the sql below to indicate the rownum.
then router the data according to the rownum from upstream.

select t.*,rownum rn from test t
where mod(floor(t.rn/10),2) =0  --get the rows whose rownum 
between 1~9,20~29,etc.

Is This Answer Correct ?

5 Yes

0 No

Zslstar

Question	Asked @	Answers
Other ETL Interview Questions


Where can i get informatica certification Exam dumps and details? please forward it to emailid: krisboppana@yahoo.com	NexGen	157
what is the difference between OLTP database and data warehousing database?		2
In the SEQ generator which property has to be set to generate seq No. when the input data is more than the max limit.	Accenture	3
what is a parameter when and where do u them when does the value will be created. Designing time, run time. If u don't create parameter what will happen?		1
how do u implement scheduling in Informatica?		1
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.		1
what are the different forms of normalization?		2
how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.		1
list the transformation used for the following:Heterogeneous sources,Homogeneous sources,Find the 5 highest paid employees with in a dept,create a summery table,generate surrogate keys		1
what are the different Reporting and ETL tools available in the market?		2
what is the difference between OLTP database and data warehousing database?		1
Eliminating of duplicate records without using dynamic lookups		2
how do u set the size of block buffer?		1
what are Lookup caches options? Including persistent caches.		1
what happens if the info.server doesn't find the session parameter in the parameter file?		2
what is the meant by Normalization and de-normalization?		1
what are variable ports and list two situations when they can be used?	Satyam	3
Eliminating of duplicate records without using dynamic lookups	IBM	3
if u can't find what you are looking for in lookup table, how do you handle?		1
how do u automate Extraction process?		1

For more ETL Interview Questions Click Here


Copyright Policy \| Terms of Service \| Help \| Site Map 1 \| Articles \| Site Map \| Site Map \| Contact Us \|

Copyright © 2007 ALLInterview.com. All Rights Reserved.

ALLInterview.com :: Forum9.com :: KalAajKal.com