How do you handle two sessions in Informatica
No Answer is Posted For this Question
Be the First to Post Answer
wat s mapping parameter and mapping variable? how do you set that in a mapping?
What are the different threads in DTM process?
what is hash table in informatica?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?
what is the use of Data Mart?
what is the architecture of any Data warehousing project?
how will u get 1 and 3rd and 5th records in table what is the query in oracle please help me
what r the propertes of workflow? and write quary to select dept more ten employess in dept.?
i have a source which relational.I am trying to populate to target flat file with one column for daily date which is sysdate. I want to populate the sysdate coulmn with DD/MM/YYYY format. kindly provide a solution for this..my clear that my target is flat file.
Hi All, i have question regarding Change Data Capture in Informatica. As i know we can do this using Incremental Aggregation(i never worked on Informatica but i read) and i think we can do the same with SQL Over write and with variables. Can someone tell me how do we do this using other two techniques.. using SQL Over write and variables. Thanks for the help and greatly appreciated.
write sql query following table quarter sales q1 1000 q1 2000 q1 3000 q1 4000 q2 5000 q2 6000 q2 7000 q2 8000 q3 1000 q3 2000 q3 3000 q3 4000 q4 5000 q4 6000 q4 7000 q4 8000 i want the output format like q1 q2 q3 q4 1000 5000 1000 5000 2000 6000 2000 6000 3000 7000 3000 7000 4000 8000 4000 8000