i have two source data there is no pk,fk how to join the
two sources
Answer Posted / prathap
if the two sources or coming from different sources then we
use joiner transformation and add a dummy prot
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
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.
lookup transformation with screenshots
Enlist the tasks for which source qualifier transformation is used.
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
How to partition the Session?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What is source qualifier transformation in informatica?
Explain sessions. Explain how batches are used to combine executions?
What is informatica etl tool?
What are the differences between a connected lookup and unconnected lookup?
How to create a non-reusable instance of reusable transformations?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance