i have two source data there is no pk,fk how to join the
two sources
Answer Posted / chandranmca2007
We can create a a dummy columns for both tables using that
dummy column we can join the both tables. If the both
tables have same column means we can using that join the
both tables.
If I wrong please send the answer to my mail id
chandranmca2007@gmail.com
Is This Answer Correct ? | 21 Yes | 6 No |
Post New Answer View All Answers
Explain the informatica workflow?
What is the use of code page?
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.
Briefly describe lookup transformation?
How do you handle two sessions in Informatica
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What is substr in informatica?
What is union transformation?
how tokens will generate?
What is the different lookup cache(s)?
Explain direct and indirect flat file loading (source file type) - informatica
How do you convert single row from source into three rows into target?
Informatica settings are available in which file?
What is informatica?