What is granularity? Please explain with example
Answer / lakshmi
Granularity defines the extent of details
Example:Let us look at geographical level of granularity.We may analyze data at the levels of country,region,territory,city and street.In this case,highest level of granularity is street.
| Is This Answer Correct ? | 0 Yes | 0 No |
Can we parametrize the values of IN statement. Ex. Inside parameter file: Parameter='A','B','C' Inside Code: IN (INPUT_CHARACTER, $$Parameter)
how do u implement unconn.stored proc. in a mapping?
What do you understand by the term ‘transformation’?
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.
Explain about round-robi?
what are the parts of Informatica server ?
what is the difference between shortcut of an object and copy of an object? compare them?
what is the difference between cubes and package in cognos
What are the steps involved in etl process?
What are cubes and olap cubes?
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
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)