Hello,
I have the below table:
CityID CityName CostOfLiving
1 Mumbai 5000
1 Bangalore 4500
1 Chennai 4800
2 Vapi 6000
3 New Delhi 8000
I am passing the rows of the above table through the
aggregator transformation in Informatica
What happens in the following conditions:
1) I specify no group-by ports?
2) I specify a group-by on CityID without making any
separate post for aggregation? Which city and costofliving
will this eventually take for CityID=1?
3) Rest being same as point 2,I take the sum of cost of
living.Which city will be returned for ID=1?
Thanks for your help!
what is the logic will you implement to laod the data in to one factv from 'n' number of dimension?
in realtime which situations u can use unconnected lookup transformation
How can we create index after completion of load process?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
What is the sql query overwrite in source qualifier in informatica
What is synonym?
what is the logic will you implement to load data into a fact table from n dimension tables?
in oracle write query yourname+1 from dual
what is incremental aggregation ,with example?
1)What is Data Masking in informatica? 2)How to restrict junk characters while loading data into target. 3) what happen if i won't pass sorted input in a transformation.
how can we convert a column into row in informatica? Eg: INPUT- a x Output Like: a b c b y x y z c z
What is the difference between Bulk Load and Normal Load