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.
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)
what is a parameter when and where do u them when does the value will be created. Designing time, run time. If u don't create parameter what will happen?
List few etl bugs?
When do we go for the tools in the market?
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
my name is amar i want display 1st line A 2nd line M 3rd line A 4th line R in database & informatica
Explain what is etl process? How many steps etl contains explain with example?
What are the types of Data Warehouse applications?
what is Forward,Reverse and Re_engineering?
can cubes contain measures ?
What are the different ways to deploy the code in informatica?
1 Answers IBM, Saama Tech, Wipro,
I have a Flat file with more no. of Records also including duplicate values. But i need distinct values to one target and remaining records to another target in Informatica way