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 |
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
What do you understand by active and passive transformations?
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
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
What are the key benefits of ETL Testing?
Difference between flat files and relational sources?
what is the difference between cardinality and Nullability?
Can u access a repository created in previous version of Informatica?
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
how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.
Eliminating of duplicate records without using dynamic lookups
Explain about the data integration suite features?