I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
No Answer is Posted For this Question
Be the First to Post Answer
What is a surrogate key?Why we use it in a mapping?Pl give an example.
differences between service based and product based?
What is Target Update Override? What is the Use ?
What are active transformations.
from Source 100 rows are coming, on target there are 5 m rows which options is better to match data 1. Joiner 2 No cache 3. Static 4. Dynamic
when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/
How to Create a folder using pmrep command?
In development project what is the process to follow for an etl developer from day1
write a query to follwoing table amount year quarter 254556 2003 first 546332 2003 second 129034 2003 third 490223 2003 fourth 165768 2004 first 265443 2004 second 510412 2004 third 435690 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 254556 546332 129034 490223 2004 165768 265443 510412 435690
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Can anyone tell me, when a flat file contains different kinds of delimeters available for each line ( For Ex: First line contains [,*&#$] and second line contains [%@$#%^]. Like that all records having different kinds of delimeters. How can we implement this kind of flat file in informatica?
Using Informatica Visio to generate mappings. I am getting error "Table Definition Not Found Exception Error" while importing the template.