HOW TO YOU LOAD TIME DIMENSION
During the running session, output files are created by informatica server. Enlist few of them.
star and snowflake schema?
how lookup is acting as both active and passive ? how is it possitble?
How to run a session, which contains mapplet?
By using Transformation i need top most 5 employee salary from each deptwise? Deptno 10,20,30? which transformation we need to use?
Hi, Can someone send me the DWH and Informatica FAQ's at priti.singh84@gmail.com Thanks in Advance, preeti
How do you load alternate records into different tables through mapping flow?
How to join three sources using joiner?
if i have records like these (source table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk 10001 gfhgdgh 10002 hjkdghkfh the target table should be like these by using expression tranformation. (Target table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk xx001 gfhgdgh xx002 hjkdghkfh (that means duplicated records should contain XX in there rowid)
What is a code page in Informatica
3 Answers American Express, Cognizant, Deloitte,
Hi,tell me the system testing and Integration Testing in the Informatica ? Thank You
if suppose i have 3 columns namely 1,2,3 in table a and 1,2,3 in table b Now in table a 1,2 and table b 1,2 columns are having same data.now based on this two columns either data should get inserted or updated. How do i write a sql query to check whether the data is populated correctly or not