Explain the difference between a data warehouse and a data mart?
No Answer is Posted For this Question
Be the First to Post Answer
State the limitations where we cannot use joiner in the mapping pipeline?
waht type of interface is used for testing the data in informatica
i have a source with 100 records.i have 2 targets.in the first target i want to load first 50 records & in the second target i want to load next 50(or remaining) records.
in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?
Can you please mail me a copy of Informatica Certification Exam dumps to sriveniv@hotmail.com
Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR IN ORACLE & INFORMATICA LEVEL HOW TO ACHIVE
In Real Time what are the scenarios u faced, what r the tough situations u have overcome, and explain about sessions.
2 Answers Cap Gemini, CTS, TCS, Tech Mahindra, Wipro,
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
write a sql query following table some duplicate present 1 1 2 2 3 3 4 5 i want the output unique one column duplicate another column following format like unique duplicate 1 1 2 2 3 3 4 5
COM components can be used in Informatica
What are the technical challenges faced in Informatica production support member? Give any one example and how to solve it?
two tables from two different databases r there . both having same structure but different data . how to compare these two tables ?