how to do aggregation (year wise quantity ) using only
source qualifier, the source is sql server date as datetime
data type and
target as flat file with year (string datatype)
No Answer is Posted For this Question
Be the First to Post Answer
1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?
How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)
0 Answers IBM, Saama Tech, Wipro,
how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.
What is partitioning? Explain about round-robin, hash partitioning.
give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.
Explain about round-robi?
how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.
when should one create lookup transformation ?
Explain the key challenges that you face while performing etl testing.
When do we analyze the tables? How do we do it?
What are various etl tools in the market?
If you concatenate data from a normalizer transformation,the ports you concatenate cannot include OCCURS(T/F).