Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


How can write SQL Overwrite to get Daynamic rows from the
source in SQ transformation!(Any Example)



How can write SQL Overwrite to get Daynamic rows from the source in SQ transformation!(Any Example..

Answer / sarvesh

by using the sql override option in the edit properties in
s.q transformation,

Is This Answer Correct ?    2 Yes 2 No

Post New Answer

More ETL Interview Questions

What are the three tiers in etl?

0 Answers  


working of line item dimension......pls,tell overall flow

1 Answers  


Hi please try to reply with answer. my mail id is raghu.1028@gmail.com. if the source is having millions of records, but having theree target tables. As per user the first record need to insert into first target and second record in to a second target and third into third target, similarly the process needs to repeat?

5 Answers  


what is granularity in Data ware House?

0 Answers   IBM,


how do u set partition points in the mapping?

0 Answers   Quintiles,


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

3 Answers  


What is virtual Data Warehousing?

0 Answers  


What are the key benefits of ETL Testing?

0 Answers  


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

2 Answers  


how do u handle performance issues in Informatica . where can u monitor the performance ?

0 Answers  


What are the different etl testing categories as per their function?

0 Answers  


Compare ETL & Manual development?

0 Answers  


Categories