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.
No Answer is Posted For this Question
Be the First to Post Answer
how to connect to a flatfile through ftp in informatica
how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.
What is tracing level? How many types of transformations supported by sorted input?
Do we need an etl tool?
I have two tables in two different database, so to join these tables which transformation will be better joiner transformation or lookup transformation?
2 Answers Accenture, Saama Tech, TCS,
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
Can we parametrize the values of IN statement. Ex. Inside parameter file: Parameter='A','B','C' Inside Code: IN (INPUT_CHARACTER, $$Parameter)
what is session partitioning?
Eliminating of duplicate records without using dynamic lookups
what is session partitioning?
what is the difference between normal & bulk loading? and which one is recommended ? why?
what is dynamic insert?