Informatica software installation 8.1/7.1.3/7.1 with oracle
10g database (optional Teradata v2R6)
How many transformations can be used in mapplets.
Difference Between ETL & ELT?
what is session parameters?
write a query to remove null value follwing table? col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output col1 col2 col3 dinesh suresh prakesh
What is informatica? What exactly are the practical uses in real world
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?
What are data-driven sessions?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
Is it possible to revert a global repository to local one and why?
what is data driven?
How will u find weather dimension table is big in size of a fact table?
how we can add header and footer to flat files?
2 Answers Tech Mahindra, Zensar,