How to compare Source and Target table, without using
dynamic lookup?
Answer Posted / xxx
Using Unconnected LKP transformation
| Is This Answer Correct ? | 0 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 are the popular informatica products?
What are connected or unconnected transformations?
What is difference between a gateway node and worker node?
How many input parameters can exist in an unconnected lookup?
What does refresh system mean, and what are its distinctive choice?
Different qualification between a related rotate toward the sky and isolates look upward?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What is the use of an aggregator cache file?
Differentiate between a database and data warehouse?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What is flashback table ? Advance thanks
What are the main features of Oracle 8i with context to datawarehouse?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What is the difference between router and filter?