How many input parameters can exist in an unconnected lookup?
If we use only lookup transformation in a mapping ie, SourceQualifier-->Lookup --> Target. , here datas are taking very long time to load in target., so what are steps to improve the performance in that mapping???????
what are the reusable tasks in informatica ?
11 Answers CTS, HP, IBM, TCS,
how to return multiple columes through through un-connect lookup?
Which one is better performance wise connected/un-connected lkp?why?
every DWH must have time dimension so now what is the use of the time dimension how we can calculate sales for one month,half-yr'ly,and year'ly?how we are doing this using time dimension.
what is the main advantage of unconnected lookup
How to improve the performance of Aggregate transformation?
Major difference between SQL override and Lookup Sql override
How the dimensions will be loaded?
What is incremental aggregation and how it is done?
8 Answers JPMorgan Chase, TCS,
I have been working in Informix-4gl for the past 2 years in an MNC company.But I'm interested to work in Business Intelligence tools. Is it possible to change the technology now? I'm really confused, please help me
scenario where i can use only concurrent execution of workflow.