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
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
Eliminating of duplicate records without using dynamic lookups
what are the session parameters? How do u set them?
what is a worklet?
how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance
What is a lookup table in etl?
what are the production issues in datastage?
Can we parametrize the values of IN statement. Ex. Inside parameter file: Parameter='A','B','C' Inside Code: IN (INPUT_CHARACTER, $$Parameter)
what is granularity in Data ware House?
What is Relational Integrity?
what is an ETL or ETT? And what are the different types?
what make u disappointmnets in u r career