What is rank transformation?
No Answer is Posted For this Question
Be the First to Post Answer
When the informatica server marks that a batch is failed?
What is flashback table ? Advance thanks
Which is better performance wise database or file?How?
A mapping contains (1) Source Table S_Time ( Start_Year, End_Year ) (2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )
if we have certain records,if i need to get 5 th rec for the first time to the target,when i run it for next time,i need to get 6th rec...like that it should process.what wil be the procedure to achieve it??
What is the actual work done in Development and in the production depts in building a datawarehouse. Which dept is more interesting and career oriented .
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What is difference between Mapplet and reusable transformation?
How informatica recognizes mapping?
Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptno; Avg (sum (Sal)) o f all deptno= 9675 Deptno, sum (Sal) 10 8750 20 10875 30 9400
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.,,
what are the row and column separations in Flat Files