in flatfile target how can u create header and footer plese give me the comands how will u write in session properties3 7507
i want to convert below src into target src is as follows maths 30 science 20 social 81 i want data in trg like below maths science social 30 20 812 5791
What is the internal processes of integration server in Informatica? How data will be extract and load to the target?
write a query row to column follwing source? quarter sales q1 5000 q1 9000 q1 7000 q1 6000 q2 5000 q2 4000 q2 3000 q2 1000 q3 4000 q3 3000 q3 1000 q3 2000 q4 5000 q4 400 i want the output? q1 q2 q3 q4 sales3 5217
what is the size ur source like(file system or database)? how many record daily come u r banking project?1341
in aggregator transformation we want to get middle record how to implement, source containg empno,name sal,deptno,address
What is enterprise data warehousing?
How to generate or load values in to the target table based on a column value using informatica etl tool.
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- firstname.lastname@example.org
What are the popular informatica products?
Explain direct and indirect flat file loading (source file type) - informatica
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
How to update or delete the rows in a target, which do not have key fields?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Explian the connected and unconnected lookup transformation
How can you validate all mappings in the repository simultaneously?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
Differentiate between sessions and batches?
Design a mapping to load the cumulative sum of salaries of employees into target table?