What is a design?
How you count the number of records available at your source?
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.
Please create a mapping where I have source which has one column with name like Aman_Gupta Rakesh_Mehra Sachin_More I want the target field should contain the name in reverse order i.e Gupta_Aman Mehra_Rakesh More_Sachin. Can you please tell me what transformation would be needed to do this.
Could any one to tell How to use the Oracle Analytic functions in Informatica?
in which situations do u go for scds ?
explain abt ur project architecture?
0 Answers Anthem, DELL, IBM, TCS, Wipro,
If you have 10 mappings designed and you need to implement some chages (may be in existing mapping or new mapping need to be designed) then how much time it takes from easier to complex?
My questions is i create a two sessions for one mapping.but my requirement is if all number of source records are same as in target then execute first session or some rows are rejected due to t/r logic so session two was execute please clarify
What is predefined event?
What are teh different tasks that can be created in workflow manager?
if the column name in sql override is diff from the column name in source qualifier,what is the impact?
How can we handle two sessions in informatica?