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
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What is meant by target load plan?
Differentiate between Load Manager and DTM?
Explain what are the different versions of informatica?
what is the hint? how to use it to reduce the query processing in program?
What are the differences between oltp and olap?
What do you understand by term role-playing dimension?
how to create user defined function (udf) in informatica
How many ways are there to do 'remove duplicate records in informatica'?
What are ETL Tools?
How many ways are there to create ports?
expain about the tune parameters?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What is DR strategy for Informatica project?
Slowly changing dimensions, types and where will you use them