Mention a few design and development best practices for informatica?
why we use stored procedure transformation?
how tokens will generate?
Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is loaded first Fact Table or Dimensions Table into the warehouse? What is the size of the Fact Table and Dimension Table? what is the size of the table and warehouse
how we can do session partition in informatica any one explain me clearly? thanks advance.
empno sal 1 8000 2 9000 3 8000 4 1000 how to get highest sal wise rankings in rank t/r.
can we override a native sql query within informatica? How do we do it?
what are the challenge face in u r project?explain me
The structure of source file is as below: Source structure(two fields) Name, Card NUmber A, 111111111(SSN) A, 01010101(Creditcard number) A, 34343434(Debit card number) B, 55555555(Creditcard number) C, 77777777(Debit card number) Target Structure(4 fields) Name,Credit card,SSN,Debit card A,01010101,111111111, 34343434 B,55555555,, C,,,77777777 Corresponding to one name there can be maximum 3 rows and minimum zero rows. Given that I do not know which record might have a particular type of number. How can I handle above requirement with informatica transformations?
How we can confirm all mappings in the repository simultaneously?
can you please explain me pre session and post session options?
WAT IS THE MEANING OF UPGRADTION OF REPOSITORY?
When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?