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

how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?

0 Answers  


What do you understand by active and passive transformations?

0 Answers  


Hello all, Source Table(Flat File):- Target Table(Flat File):- Date Date 01/08/2008(DD/MM/YYYY) 01/08/2008 02/08/2008 03/08/2008 04/08/2008 05/05/2008 My requiremnt is this. I need to do it by informatica,Plz tell me how can i do it? Thanks

3 Answers  


please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance

0 Answers  


What are the key benefits of ETL Testing?

0 Answers  






Difference between flat files and relational sources?

0 Answers   Satyam,


what is the difference between cardinality and Nullability?

0 Answers  


Can u access a repository created in previous version of Informatica?

1 Answers   DELL,


diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture

0 Answers   L&T,


how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.

2 Answers   CTS,


Eliminating of duplicate records without using dynamic lookups

4 Answers   IBM,


Explain about the data integration suite features?

0 Answers  


Categories