what are the types of Data warehousing ?
Mention a few design and development best practices for informatica?
What is deployemnt groups, Lables, query and dynamic deployment group.
what is the logic will you implement to load data into a fact table from n dimension tables?
why we use source qualifier transformation?
how to load dimension table and fact table. plz tell me the steps.
How are the sources and targets definitions imported in informatica designer?
If i havee 3records in my source having same deptno like Deptid Deptno ------ ------ 101 10 201 10 301 10 and i am using router TR to loading these records into target.Then how many record'll be loaded into target???
what is the exact meaning of domain?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
I have a source either file or db table Eno ename sal dept 101 sri 100 1 102 seeta 200 2 103 lax 300 3 104 ravam 76 1 105 soorp 120 2 Want to run a session 3 times. First time: it should populate dept 1 Second time: dept 2 only Third time: dept 3 only How can we do this?
How to update or delete the rows in a target, which do not have key fields?
What are the types of lookup caches?
10 Answers Accenture, IBM, Informatica,