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 |
What are the three tiers in etl?
working of line item dimension......pls,tell overall flow
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?
what is granularity in Data ware House?
how do u set partition points in the mapping?
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
What is virtual Data Warehousing?
What are the key benefits of ETL Testing?
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
how do u handle performance issues in Informatica . where can u monitor the performance ?
What are the different etl testing categories as per their function?
Compare ETL & Manual development?