Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?
Answer Posted / abhinaw prakash
We can use lookup transformation to stay away from these
problem and can lookup the target columns befor entering the
data.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How do you set a varible in incremental aggregation
What is informatica etl tool?
Explain your project of banking domian.
What is the maplet?
What does cheating measurement mean?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
What is the way to execute pl/sql script using informatica mapping?
How do you load alternate records into different tables through mapping flow?
What are the uses of etl tools?
What is the difference between informatics 7x and 8x and what is latest version?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Did u used latest transformations of 8.6.0? for what?
How to handle decimal places while importing a flatfile into informatica?
What are the types of data warehouses?