If source is having 5000 rows,and if you want to load data
into 500 rows to target,if the session runs successfully,how
can you verify the target if the rows are successfully
loaded or not.
Answers were Sorted based on User's Feedback
Answer / abhishek upadhyay
Through session log/run properties I can see how many rows
were inserted in the target table
| Is This Answer Correct ? | 15 Yes | 0 No |
Answer / raveendra g
By using Testload option, we can test the rows.
| Is This Answer Correct ? | 4 Yes | 1 No |
How to load a Dimension ? and how to load a fact table?
What is the method of seperating unique and duplicate records in session level?
2 Answers Emphasis, JBL, Wipro,
How to delete duplicate records in a flat file source?
my source table having sureshraj42@gmail.com and rajeshraj42@gmail.com and i have only sureshraj and rajeshraj for my target table which transformation i have to use in informatica
Design a mapping to get year of join for each employee.
What is informatica? Why do we need it?
What is rank transformation?
what is difference between dimention table and fact table?
if suppose i have 3 columns namely 1,2,3 in table a and 1,2,3 in table b Now in table a 1,2 and table b 1,2 columns are having same data.now based on this two columns either data should get inserted or updated. How do i write a sql query to check whether the data is populated correctly or not
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 81
What is data transformation manager process?
1)What is Data Masking in informatica? 2)How to restrict junk characters while loading data into target. 3) what happen if i won't pass sorted input in a transformation.