What are conformed dimensions?
The dimension which can be shared more than 1 fact/module called a conformed dimension. Eg: Time dimension
| Is This Answer Correct ? | 0 Yes | 0 No |
How to load last 10 records of flat file in to the target?
How IN function works in informatica? Is it similar that of oracle IN function or different? Explain
Explain sessions and how many types of sessions are there?
How do you migrate data from one environment to another?
Where are the source flat files kept before running the session?
How union transformation is active ?
case and like function in informtica (my source is XML). case when OS Like'%Windows%' and OS Like '%200%' then 'Windows 200' case when OS Like'%Windows%' and OS Like '%200%'and OS like '%64%' then 'windows 200 64 bit' etc.,,
How to update or delete the rows in a target, which do not have key fields?
in informatica,if i have some no.of records,if i want 1st and 10th records..what will be the method to use?
How many ways are there to do 'remove duplicate records in informatica'?
which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..
What are junk dimensions?