what is inline view?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
When you move from devel to prod how will you retain a variable
write s sql query following table some duplicate present i want unique one column duplicate another column display? name id a 1 a 1 b 2 b 2 c 3 i want the required output like unique duplicate name id name id a 1 a 1 b 2 b 2 c 3
suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping?how
What is the use of transformation?
i have thousand records in my source(flat file) i wanna load 990 records i don't want load first 5 records and last 5 records at informatica level?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? means only one source qualifier has 2 columns like empno, sal. connected to same target as shown in above mapping.Is this mapping valid or any issues are there if we design like this?
two tables from two different databases r there . both having same structure but different data . how to compare these two tables ?
can we use lookup t/r in flat files?what are the t/r's can be used in flat files when compared to relational DB?
How to load the data into target table, which not have Primary/Surrogate key (Duplicate records not acceptable)
ename,deptcount vamshi,3 kumar,5 krish,8 in o/p i want vamshi record 3 times kumar record 5 times like wise what is the logic.? give the entire logic plz